Finding day of week in 2030

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lisa Clamors - 18 Aug 2006 22:35 GMT

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?

Reply to this Message

Dave F - 18 Aug 2006 22:44 GMT

What formulas are you using to calculate these dates?

Signature

Brevity is the soul of wit.

> 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,
[quoted text clipped - 19 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=10d9ba95-6f25-4
c31-9023-d512096da7ca&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Pete_UK - 18 Aug 2006 23:01 GMT

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

> What formulas are you using to calculate these dates?
> --
[quoted text clipped - 23 lines]
> >
> > http://www.microsoft.com/office/community/en-us/default.mspx?mid=10d9ba95-6f25-4
c31-9023-d512096da7ca&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Pete_UK - 18 Aug 2006 23:09 GMT

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

> 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
[quoted text clipped - 31 lines]
> > >
> > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=10d9ba95-6f25-4
c31-9023-d512096da7ca&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Lisa Clamors - 23 Aug 2006 17:34 GMT

Thank you very much, Pete! It worked!

> 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
[quoted text clipped - 39 lines]
> > > >
> > > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=10d9ba95-6f25-4
c31-9023-d512096da7ca&dg=microsoft.public.excel.worksheet.functions

Reply to this Message

Pete_UK - 23 Aug 2006 17:43 GMT

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

> Thank you very much, Pete! It worked!
>
[quoted text clipped - 41 lines]
> > > > >
> > > > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=10d9ba95-6f25-4
c31-9023-d512096da7ca&dg=microsoft.public.excel.worksheet.functions

Reply to this Message