V
Vance
I am looking for a formula that I can use in Excel to track
how many days overdue an account is. Basically, I need
something that will show how many days have passed since a
specific date. For instance if the original date was
1/1/04 and todays date was 1/10/04 then the formula would
recognize todays date (1/10/04) minus the original date
(1/1/04) = 9. If possible I do not want to have to include
"todays date" in the spreadsheet...is there such a formula
that will automatically recognize "todays date"?
I would like to have the spreadsheet look something like this:
Date Invoiced: 3/1/04
Days Overdue: 14 (this number would be automatically updated)
Any response is greatly appreciated!
how many days overdue an account is. Basically, I need
something that will show how many days have passed since a
specific date. For instance if the original date was
1/1/04 and todays date was 1/10/04 then the formula would
recognize todays date (1/10/04) minus the original date
(1/1/04) = 9. If possible I do not want to have to include
"todays date" in the spreadsheet...is there such a formula
that will automatically recognize "todays date"?
I would like to have the spreadsheet look something like this:
Date Invoiced: 3/1/04
Days Overdue: 14 (this number would be automatically updated)
Any response is greatly appreciated!