Dates
thanks for all the replies...they were all helpful.
oh and i put the wrong date in (12/10/20033). that's what happens when
trying to do 2 things at once!
"John" wrote:
Sorry 25 years will bring you to Jan/31/2033
"John" wrote in message
...
To answer your question "Yes"
But I don't know where you're getting that answer ( 12/10/2033 ) 35 years
will bring you to Jan/31/2033 including 7 leap years
Regards
John
"frykid50" wrote in message
...
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?
|