Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Easter day formula.

4,011 views
Skip to first unread message

anthony coudene

unread,
Dec 4, 2000, 3:00:00 AM12/4/00
to
I know a formula to know the Easter day :
=FRANC((JOUR(MINUTE(A1/38)/2+55)&"/4/"&A1)/7;)*7-6

(where A1 is the current year)

Is there anybody who knows why this formula works ?

Thanks,
Anthony.

George Simms

unread,
Dec 4, 2000, 3:00:00 AM12/4/00
to
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.

"anthony coudene" wrote in message
news:#Qhg$8iXAH...@cppssbbsa02.microsoft.com...

George Simms

unread,
Dec 7, 2000, 3:00:00 AM12/7/00
to
Hi Anthony, Doug,

I could be wrong about the formula you posted. It is similar, but not the
same formula.
Laurent Longre might know where it came from, if it's from his site.

I don't have any e-mail addresses.

The only web site I have is :

http://www.smart.net./~mmontes/ortheast.html

A few formula from the list. J = Named cell containing the year.

1st Norbert Hetterich =FLOOR(DAY(MINUTE(J/38)/2+56)&"/5/"&J,7)-34

2nd Thomas Jansen =DOLLAR(("4/"&J)/7+MOD(19*MOD(J,19)-7,30)*14%,)*7-6

3rd Roger Friederich =FLOOR(DATE(J,3,MOD(18.37*MOD(J,19)-6,29)),7)+29

The most interesting.
Prasad DV
=TRUNC(DATE(J,7,-CODE(MID("NYDQ\JT_LWBOZER]KU`",MOD(J,19)+1,1)))/7)*7+8


And 20 th Last.

George Simms
=DATE(J,3,28)+MOD(24+19*MOD(J,19),30)-(MOD(24+19*MOD(J,19),30)>27)-MOD(INT(
J
+J/4)+MOD(24+19*MOD(J,19),30)-(MOD(24+19*MOD(J,19),30)>27)+1,7)


All the Best

George Simms
Microsoft MVP
Newcastle upon Tyne
England.

"DougB" <douglas...@airshowinc.com> wrote in message
news:3a2fbd6e...@msnews.microsoft.com...
> On Mon, 4 Dec 2000 21:22:03 -0000, "George Simms"
> <Geor...@email.msn.com> wrote:
>
> What was your formula? Mine would be last, I'm sure, as it would
> probably be about 5 lines long.

Chip Pearson

unread,
Dec 7, 2000, 3:00:00 AM12/7/00
to
Just a note about the Herber's Easter Formula Contest (a year or so
ago).....

I didn't win at all (I was somewhere in the 10th to 15th place, I think),
but the "rules" of the contest were that the winning formula had to "agree
with Chip Pearson's formula" for Easter.

According to the formal rules, I should have won. My formula was simply
"=1". Of course, that's not the date of Easter, but it is the shortest
formula which agrees with mine (simple logic, Chip's Formula = Chip's
Formula).

My submission was rejected by the appeals court, I guess, and I didn't win
the prize (I think it was a case of wine).

Perhaps I shall ask for a recount.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com

"George Simms" <Geor...@email.msn.com> wrote in message
news:ubiKWKKYAHA.278@cppssbbsa04...

Anthony Coudene

unread,
Dec 7, 2000, 10:03:41 AM12/7/00
to
Thanks for this information.

But, do you have the address of Thomas Jansen or a way of finding more
explanations ?

Because the web is quite poor about that topic...

Anthony.


George Simms <Geor...@email.msn.com> a écrit dans le message :
earKwfjXAHA.197@cppssbbsa05...


> 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.

DougB

unread,
Dec 7, 2000, 11:41:11 AM12/7/00
to
On Mon, 4 Dec 2000 21:22:03 -0000, "George Simms"
<Geor...@email.msn.com> wrote:

What was your formula? Mine would be last, I'm sure, as it would
probably be about 5 lines long.

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

Dana DeLouis

unread,
Dec 8, 2000, 4:42:05 PM12/8/00
to
This seems interesting:

Easter Dating Method
by Ronald W. Mallen
Astronomical Society of South Australia

http://www.assa.org.au/edm.html

Easter Dating
http://www.cobweb.com.au/~gmarts/easter.htm

Dana


"Anthony Coudene" <anthony...@libertysurf.fr> wrote in message
news:e9uGa3FYAHA.196@cppssbbsa05...


> Thanks for this information.
>
> But, do you have the address of Thomas Jansen or a way of finding more
> explanations ?
>
> Because the web is quite poor about that topic...
>
> Anthony.

<snip>

henner juengst

unread,
Dec 9, 2000, 6:22:07 AM12/9/00
to
"Anthony Coudene" <anthony...@libertysurf.fr> wrote:

Hi,

>Thanks for this information.
>
>But, do you have the address of Thomas Jansen or a way of finding more
>explanations ?

The adress is: Jansen...@t-online.de

Peltier

unread,
Dec 9, 2000, 6:08:07 PM12/9/00
to
Just wondering...

Has anyone extended this to calculation of Eastern Orthodox Easter?

- Jon
_______

> > All the Best
> >
> > George Simms
> > Microsoft MVP
> > Newcastle upon Tyne
> > England.
> >
> >
> >

> > "DougB" <douglas...@airshowinc.com> wrote in message
> > news:3a2fbd6e...@msnews.microsoft.com...

dave pritchard

unread,
Dec 16, 2000, 7:29:38 PM12/16/00
to

Given the timing of these posts, is it possible to do this for Christmas
Day?

Thanks
Dave
> > >


David McRitchie

unread,
Dec 16, 2000, 9:26:04 PM12/16/00
to
Hi Dave,
As long as you are talking about Dec 25 as Christmas Day
it's very easy. Easter Sunday falls on different dates on
different years.

A2 =2000
B2 =WEEKDAY(DATE(A2,12,25)) format as ddd

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm

dave pritchard <da...@beachpalms.com.au> wrote in message
news:eliQis8ZAHA.1380@tkmsftngp04...

Chip Pearson

unread,
Dec 17, 2000, 11:32:22 PM12/17/00
to
While this works, it is a bit redundant. Why use WEEKDAY at all? Just use

=DATE(A2,12,25)

and format as ddd or dddd. WEEKDAY only works because Excel (and Lotus)
screwed up dates prior to 1-March-1900. It *shouldn't* work, but it does.

And if the question is about the day-of-week of holidays, Easter is
trivially simple, =1. Computing the date of Easter is hard. Computing the
day-of-week of Easter (or any holiday) is extremely simple.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com ch...@cpearson.com


"David McRitchie" <DMcRi...@msn.com> wrote in message
news:OliB#C9ZAHA.2100@tkmsftngp05...

checkma...@gmail.com

unread,
Apr 14, 2013, 7:55:03 AM4/14/13
to
Hello George Simms,


" 1 st Norbert Hetterich =FLOOR(DAY(MINUTE(J/38)/2+56)&"/5/"&J,7)-34 "
I try on excel that didn't give solusion, I browse in other web I find this formula
= FLOOR("5/"&DAY(MINUTE(A1/38)/2+56)&"/"&A1,7)-34
it work

David2me

unread,
Jan 11, 2020, 2:56:24 PM1/11/20
to
Thanks for the formula. Just a note for those looking to use the formula. The cell reference is for the year. A cut-n-paste formula for google sheets is :

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

It replaces the cell reference with the formula for the current year. An auto updating Easter formula.
0 new messages