Excel 2007 Problem with 2008 Calendar

[Ted]

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

 

[Chirag]

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]

YOU ARE CORRECT. My goof. Thanks a bunch.