Thread: Dates
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Dates

Thanks for the feedback. Be sure to indicate by checking the YES box below
that your question has been answered :)
--
** John C **

"frykid50" wrote:

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?