Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding day of week in 2030
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding day of week in 2030
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding day of week in 2030
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding day of week in 2030
Thanks for feeding back, Lisa.
I didn't state the obvious - rather than adjusting the cutoff year, you could have ensured that all your dates included the century in the year. Pete Lisa Clamors wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding current week and if any item has somthing due | Excel Worksheet Functions | |||
Finding the Monday date based on a different date in same week | Excel Worksheet Functions | |||
Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Macro to insert copied cells | Excel Discussion (Misc queries) | |||
user defined function | Excel Worksheet Functions |