W
William
Consider the following formula:
=(Date1+1094)-Date2
If I run that formula using the following dates:
(02/25/2005+1094)-02/25/2008, the answer is -1.00.
If I run the same formula with these dates:
(04/16/2005+1094)-04/16/2008, the answer is -2.00!
HELP!! How can this happen?!
In case you're wondering, 2005 was NOT a leap year (2004 and 2008 were).
=(Date1+1094)-Date2
If I run that formula using the following dates:
(02/25/2005+1094)-02/25/2008, the answer is -1.00.
If I run the same formula with these dates:
(04/16/2005+1094)-04/16/2008, the answer is -2.00!
HELP!! How can this happen?!
In case you're wondering, 2005 was NOT a leap year (2004 and 2008 were).