Dates
Leap years are already incorporated into the serial calendar used by Excel,
so you don't need to account for them. It's a done deal.
--
Kevin Backmann
"frykid50" wrote:
I have a date (1/31/08) and I need to add 25 years to it. I know the formula
to do this (=Date(YEAR(A4)+B4,MONTH(A4),DAY(A4)) where the answer is
12/10/2033. No problem. However, does this account for a leap year?
|