MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Calander Date Calculations

Posted by Joe on August 21, 2001 9:19 AM

If 01/01/00 is in A1 and 01/02/01 is in A2, I want A3 to show me a value of 366 (the total number of days that have gone by). Any ideas on a formula to calculate this?

Posted by Aladin Akyurek on August 21, 2001 9:27 AM

In A3 enter: =A2-A1

(where A2>A1 assumed) & number or general format A3.


Posted by IML on August 21, 2001 9:27 AM

=A2-A1 and format as general. the result is 367 (leap year).

good luck.