Exactly, so the second includes an extra day for 2008.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"William" wrote in message
...
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).
--
William