2008 Leap Year

  • Thread starter Thread starter Siberian
  • Start date Start date
S

Siberian

Is it just me or does Excel 2007 not handle the leap year. I had a
sheet where my header labels were dates every two weeks using date +
14 days. Feb 15 + 14 is the 29th, not March 1st. Running 2007 with
SPs
 
Im using Excel 2007. I entered 2/15/2008 in A1 in B1 I put =A1+14 and got
2/29/2008

Tyro
 
Make sure that the Feb 15 date is actually 2008 - if you format the cell for
mmm dd, you are hiding the year.

Bernie
 
Is it just me or does Excel 2007 not handle the leap year. I had a
sheet where my header labels were dates every two weeks using date +
14 days. Feb 15 + 14 is the 29th, not March 1st. Running 2007 with
SPs
Click to expand...

Post the formula and source data you are using to generate your header labels.
Perhaps you're using the wrong year?
--ron
 
Back
Top