LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Finding day of week in 2030

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding current week and if any item has somthing due Robert Brown Excel Worksheet Functions 2 July 19th 06 02:15 PM
Finding the Monday date based on a different date in same week dandiehl Excel Worksheet Functions 4 April 11th 06 06:03 PM
Macro to copy cells to rows below [email protected] Excel Discussion (Misc queries) 1 January 20th 06 06:59 PM
Macro to insert copied cells [email protected] Excel Discussion (Misc queries) 17 January 18th 06 10:40 AM
user defined function Brian Rogge Excel Worksheet Functions 5 May 23rd 05 06:21 PM


All times are GMT +1. The time now is 06:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"