Excel template for the date of Easter

[Guest]

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?

 

[Frank Kabel]

Hi
see:
http://tinyurl.com/3lttf

 

[Guest]

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

 

[Barbara Wiseman]

Dadgum,
Chip Pearson has a good section on dates & times including Easter
http://www.cpearson.com/excel/holidays.htm#Easter

Barbara