MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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