View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa Clamors Lisa Clamors is offline
external usenet poster
 
Posts: 1
Default Finding day of week in 2030

Thank you very much, Pete! It worked!

"Pete_UK" wrote:

Sorry, I didn't tell you how to change it - you can specify the cutoff
year (default is 29/30) from the Regional Setting control in the
Windows Control Panel. This would then apply to all Office programs.

Hope this helps.

Pete

Pete_UK wrote:
I suspect that you are not using the full century in your formulae.
Excel is set up (though you can change this) to convert years without a
century to 19xx if xx is 30 or more, and to 20xx if xx is less than 30.

Hope this helps.

Pete

Dave F wrote:
What formulas are you using to calculate these dates?
--
Brevity is the soul of wit.


"Lisa Clamors" wrote:

I have an Excel speadsheet which calculates the day of the week for Easter
from 2007 - 2050. Through 2029 Easter is always on a Sunday. For example,
in 2029 Easter Sunday is April 1. In 2030 April 1 should be a Monday since
it is a Sunday in 2029 and 2030 is not a leap year. Therefore, April 22 will
also be a Monday. However, Easter Sunday April 21, 2030, is calculated as a
Monday, not Sunday.

All of the Easter dates through 2050 calculate as Mondays.

I checked another Calendar program, and April 21, 2030, was shown to be a
Sunday.

I am using Office 2002, I feel this error should be corrected. Does anyone
know if it has been? If so, where would I find the update?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions