Date Calculations In MS Excel?

In one field, I have "Due Dates" which are static and won't change. I would like to create another field that will compare the due date against Today's Date (each time the spread sheet is open) and calculate a number of days the account is past due.





ie. Today - Due Date = # of days past due.





I just can't figure it out. Any help would be great.


Thanks,


Tony

Date Calculations In MS Excel?
You will have to make some kind of formula, but how you input the data can effect it.
Reply:its very very very very very very very very very very VERY





easy to do this..





to get TODAYS date, you enter =today()





in any cell you please.








Then, in the column beside your due date, you have





your cell referencing today- the due date, and then format THAT cell for a normal number.
Reply:cell formula





Say due date is in cell A1





B1 formula


=TODAY() - A1





If youwant time as well then





= NOW() - A1