Thread: Dates
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Dates

Easy enough to try - put 29 Feb 2008 in A4 and 25 in B4 and your
formula will return 1st March 2033, as there is no 29th Feb that year.
So, the formula does account for leap years, but when you start with
Leap Day you will get 1st March of the year 25 years hence. If you
start with 28th Feb, you will still get 28th Feb but 25 years on.

I'm not sure how you get your answer though - what did you have in B4?

Hope this helps.

Pete

On Nov 12, 5:13*pm, 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?