Thank you David. I should have known that George would have had a very good
reason for specifying the limit.
--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"David Biddulph" wrote in message
...
For 2079 it gives 16th April, whereas the formula from
http://aa.usno.navy.mil/faq/docs/easter.html gives 23 April. The latter
date is confirmed by http://www.ely.anglican.org/cgi-bin/easter, so I
think that the limitation to 2078 was deliberate.
--
David Biddulph

"Sandy Mann" wrote in message
...
Sorry OC, I should have said. A1 contains the year as a plain number (
ie 2006 or 2007 etc) therefore Easter in 2078 will be on April 3rd.

I just can't wait to see if it is right! <g

Actually George only said that it was correct up to 2078. I don't know
if that was only as far as he went but it agrees with a Easter calculator
that I found on the net for the year 3050.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"OC" wrote in message
...
Sandy,
What would go in A1? I've been playing around with it and can't get
anything to work. Got any ideas?

Thanks,
OC


"Sandy Mann" wrote:

"OC" wrote in message
...

got to Memorial Day and Easter. I decided to scrap Easter due to it
being
based on the lunar cycle, had no idea how to calculate that one.

You and me both but here is a post by the late George Simms from 4 Dec
2000:

Start of George's Post
************************************************** ***********
Hi Anthony,

This formula was by Thomas Jansen from Germany. It came second in a
contest
to find the shortest formula to calculate the date for Easter Sunday
for
any year between 1900 to 2078. You will need to ask him the "how" and
"why" it works.

The winning formula was by Norbert Hetterich from Germany with :

=FLOOR(DAY(MINUTE(A1/38)/2+56)&"/5/"&A1,7)-34

Again I don't know how and why it works, but it does.

The contest was run by Hans Herber http://www.herber.de

BTW. I came 20th (Last) <bg

All the Best

George Simms
Microsoft MVP
Newcastle upon Tyne
England
************************************************** ***
End of Geogre's post

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk