Date Arithmetic
Posted by Joseph Prusinski on May 10, 2001 11:52 AM
I know how to determine the number of days between two dates in Lotus simply subtracting one from the other, e.g. (a1-a2) where a1 is dec 31, 2000 and a2 is january 1, 2000 - result is 365.
When I apply the formula =a1-a2 in Excel I get 12/30/1900.
What is the correct way to do date arithmetic in Excel?
TYVM!!!
Posted by Dave Hawley on May 10, 2001 12:00 PM
Hi Joseph
Excel is the same, all it's doing is apply a date Format to the cell, because the cells you are referencing are Dates. Change it to General.
...or use
=DATEDIF(F4,F16,"d")
Where F4 is the earliest date.
Dave
OzGrid Business Applications
