2008 Leap Year

[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

 

[Jim Cone]

Check your calendar again.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"Siberian"
<[email protected]>
wrote in message
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

 

[Tyro]

Im using Excel 2007. I entered 2/15/2008 in A1 in B1 I put =A1+14 and got
2/29/2008

Tyro

 

[Bernie Deitrick]

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

Bernie

 

[Ron Rosenfeld]

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

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