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.
Aladin
Posted by IML on August 21, 2001 9:27 AM
=A2-A1 and format as general. the result is 367 (leap year).
good luck.
