Excel 2007 Problem with 2008 Calendar

When using the fill button for dates in Excel 2007 I encountered this problem:

2/11... 2/18... 2/25... 3/4 (should have been 3/3 as Monday in 2008 is
March 3 not March 4).

When looking at Microsoft Calendar templates in Excel for 2008 the dates for
MArch look correct.

Is there a leap year problem in Excel 2007?
Ted

It is probably reading the year for 2/11 as 2007 and not 2008. When I gave
2/11/2008 with display as 2/11, it calculates the correct series fill 3/3
for Monday, March 3.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

"Ted" <Ted@discussions.microsoft.com> wrote in message
news6E9F969-EA4E-4E42-A14B-D687041876AE@microsoft.com...
> When using the fill button for dates in Excel 2007 I encountered this
> problem:
>
> 2/11... 2/18... 2/25... 3/4 (should have been 3/3 as Monday in 2008 is
> March 3 not March 4).
>
> When looking at Microsoft Calendar templates in Excel for 2008 the dates
> for
> MArch look correct.
>
> Is there a leap year problem in Excel 2007?
> Ted

YOU ARE CORRECT. My goof. Thanks a bunch.
--
Ted


"Chirag" wrote:

> It is probably reading the year for 2/11 as 2007 and not 2008. When I gave
> 2/11/2008 with display as 2/11, it calculates the correct series fill 3/3
> for Monday, March 3.
>
> - Chirag
>
> PowerShow - View multiple PowerPoint slide shows simultaneously
> http://officeone.mvps.org/powershow/powershow.html
>
> "Ted" <Ted@discussions.microsoft.com> wrote in message
> news6E9F969-EA4E-4E42-A14B-D687041876AE@microsoft.com...
> > When using the fill button for dates in Excel 2007 I encountered this
> > problem:
> >
> > 2/11... 2/18... 2/25... 3/4 (should have been 3/3 as Monday in 2008 is
> > March 3 not March 4).
> >
> > When looking at Microsoft Calendar templates in Excel for 2008 the dates
> > for
> > MArch look correct.
> >
> > Is there a leap year problem in Excel 2007?
> > Ted
>