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?


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


Where F4 is the earliest date.


OzGrid Business Applications