Thread: Dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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?