Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Vista General Discussion > Excel 2007 Problem with 2008 Calendar

Reply
Thread Tools Display Modes

Excel 2007 Problem with 2008 Calendar

 
 
Ted
Guest
Posts: n/a

 
      12-25-2007
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
 
Reply With Quote
 
 
 
 
Chirag
Guest
Posts: n/a

 
      12-25-2007
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" <> wrote in message
news6E9F969-EA4E-4E42-A14B-...
> 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


 
Reply With Quote
 
Ted
Guest
Posts: n/a

 
      12-25-2007
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" <> wrote in message
> news6E9F969-EA4E-4E42-A14B-...
> > 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

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Craneman Windows Vista Installation 3 07-18-2007 07:22 PM
problem in faxing excel 2007 documents QS15 Windows Vista Printing / Faxing / Scanning 0 05-04-2007 02:20 AM
Windows Vista Calendar and Office 2007 Outlook Calendar Dino+ Windows Vista Installation 1 05-01-2007 02:22 PM
Excel 2007 wil not open and Excel 2007 document in Vista? lethag Windows Vista General Discussion 0 04-26-2007 08:34 PM
Outlook 2007 + WM5 sync, strange calendar problem LR Windows Vista General Discussion 1 04-13-2007 01:02 PM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59