Excel template for the date of Easter
 

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?

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

--
Regards
Frank Kabel
Frankfurt, Germany

Dadgum wrote:
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?

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

"Dadgum" wrote:

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?

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

Barbara


Dadgum wrote:
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?