|
 |  |  |  |  |  |  |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
 |
| |
12-25-2007
| #1 (permalink) |
| | 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 |
My System Specs |
|
12-25-2007
| #2 (permalink) |
| | Re: Excel 2007 Problem with 2008 Calendar 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@xxxxxx> wrote in message news  6E9F969-EA4E-4E42-A14B-D687041876AE@xxxxxxQuote: > 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 |
| My System Specs |
|
12-25-2007
| #3 (permalink) |
| | Re: Excel 2007 Problem with 2008 Calendar YOU ARE CORRECT. My goof. Thanks a bunch. -- Ted "Chirag" wrote: Quote: > 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@xxxxxx> wrote in message > news 6E9F969-EA4E-4E42-A14B-D687041876AE@xxxxxxQuote: > > 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 |
| My System Specs |
|
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| WLM 2007 (2008) --> WLM 2009: important faults. Therefore, WLM 2009 --> WLM 2007 (2008) | Live Mail | |||
| Excel 2007/ Vista- Problem Duplicating Worksheets Within Same Work | Vista General | |||
| problem in faxing excel 2007 documents | Vista print fax & scan | |||
| Excel 2007 wil not open and Excel 2007 document in Vista? | Vista General | |||
| Outlook 2007 + WM5 sync, strange calendar problem | Vista General | |||
