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

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


"Siberian"
<(E-Mail Removed)>
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

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

Tyro

"Siberian" <(E-Mail Removed)> wrote in message
news:6737a23d-ceb5-4565-99fa-(E-Mail Removed)...
> 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

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

Bernie

"Siberian" <(E-Mail Removed)> wrote in message
news:6737a23d-ceb5-4565-99fa-(E-Mail Removed)...
> 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

On Wed, 6 Feb 2008 16:23:05 -0800 (PST), Siberian <(E-Mail Removed)>
wrote:

>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