Easter day formula.
anthony coudene
=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
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
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
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
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
<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
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
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
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
Given the timing of these posts, is it possible to do this for Christmas
Day?
Thanks
Dave
> > >
David McRitchie
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
=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
" 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
=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.