Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DUE DATE FORMULA QUESTION
I have a cell that is summing up a row which could be +/- a due date. i need
a formula that will keep track of how many days that project is over the completion date, and do it on a daily basis. So evrymorning when i open the file, it will tell me the dates until due or how much over the date it is Basically telling me Project Xis 24 days overdue and then tomorrow the sheet will tell me it is 25 days over due from the initial completion date?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DUE DATE FORMULA QUESTION
ohnesorge,
If A1 is the due date then in the cell you want to have displayed the number of days to completion/overdue enter the following formula. =A1-Today() I also would suggest formatting it to one color when it is positive (days to completion) and another color when it is negative (days overdue) -- Brian "ohnesorge" wrote: I have a cell that is summing up a row which could be +/- a due date. i need a formula that will keep track of how many days that project is over the completion date, and do it on a daily basis. So evrymorning when i open the file, it will tell me the dates until due or how much over the date it is Basically telling me Project Xis 24 days overdue and then tomorrow the sheet will tell me it is 25 days over due from the initial completion date?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Date formula question | Excel Discussion (Misc queries) | |||
Date formula question | Excel Discussion (Misc queries) | |||
formula date question? | Excel Discussion (Misc queries) | |||
formula date question? | Excel Discussion (Misc queries) | |||
Formula date question | Excel Discussion (Misc queries) |