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?