Excel template for the date of Easter

D

Dadgum

Does anyone have access to an Excel template for finding the date of Easter
in any given year in the past or in the future?
 
P

Peo Sjoblom

There was a competition in Germany to find easter date in excel, I believe
this won

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6

however it won't work for Mac date system (1904), this formula by Gerhard
Somitsch will

=DATE(A1,3,29.56+0.979*MOD(204-11*MOD(A1,19),30)-
WEEKDAY(DATE(A1,3,28.56+0.979*MOD(204-11*MOD(A1,19),30))))


where you put the year in A1

Regards,

Peo Sjoblom
 
Top