Dates
Yep.
But if your starting date were Feb 29, 2008, then since there isn't a Feb 29,
2033, your suggested formula would return Mar 1, 2033.
Is that what you'd want returned?
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?
--
Dave Peterson
|