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?? |
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?? |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com