Hi all I created a log of a whole bunch of files that need frequent updates. How could I set reminders for each filed? Any help would be greatly appreciated.
2007-01-22 03:59:55 · 3 answers · asked by Bumps 1 in Computers & Internet ➔ Software
qwertkph thanks that is great info. I tried it and it woks great and that I what I am looking for but I need it to go by dates (Month/Day/year). I tried to modify the code you provided but I am doing something wrong because it dose not update. Can you help?
2007-01-22 06:11:21 · update #1
Also will this work if it is past due.
2007-01-22 06:30:08 · update #2
Interesting problem for Excel but certainly something you can do in Excel. I assume you're doing weekly updates. This means some files need update on Monday, Tuesday, etc. Here are the steps to do it:
In cell A1 put in this formula =TEXT (TODAY(), "dddd")
Create a list of file names in Column A starting in A2 or lower.
In adjacent cells (B2, B3, etc), put in the weekday that you want the file to be updated.
In C2, put in this formula =IF($A$1=B2, "Update", "")
Copy down cell C2 for as many rows that have data in them.
Each time you open the spreadsheet, the date will automatically update to current date. Cell A1 will show the day of the week and all rows that match that will show the word "Update" in column C.
You can scoll down and see the file names that require updating or you can use filtering. Either way, you will have a neat and tidy listing of update work you need to do.
Hope this helps
Kind Regards,
QwertyKPH @ Yahoo!
2007-01-22 05:07:05 · answer #1 · answered by qwertykph 4 · 1⤊ 0⤋
Use what the other guy taught you, but this time change the "dddd" in the first formula to "mm/dd/yy" and instead of putting what day of the week you want to update each program, put in the complete date in the form mm/dd/yy, and that should work.... if you just want month and day, then just erase the yy from both things.... any questions email me to cra_88@hotmail.com
2007-01-22 11:51:05 · answer #2 · answered by CRA 3 · 0⤊ 0⤋
The obvious answer is just to add 41-42 to the date. But if you want to add 30 working days, and if there is a bank holiday etc... Then it will get complected. You will probably have to have an array with the bank holidays etc... somewhere and have a conditional formula using a lookup function.
2016-05-24 17:54:50 · answer #3 · answered by Anonymous · 0⤊ 0⤋