Remember Me?

#1
December 27th 04, 04:05 PM
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?

#2
December 27th 04, 04:25 PM
 Frank Kabel Posts: n/a

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

--
Regards
Frank Kabel
Frankfurt, Germany

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?

#3
December 27th 04, 05:15 PM
 Peo Sjoblom Posts: n/a

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

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?

#4
December 28th 04, 11:04 AM
 Barbara Wiseman Posts: n/a

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

Barbara

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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post brhicks Charts and Charting in Excel 3 December 16th 04 02:54 PM teach Excel Discussion (Misc queries) 3 December 14th 04 11:55 PM Aging Analyst Excel Discussion (Misc queries) 1 December 3rd 04 03:26 AM Casey Excel Discussion (Misc queries) 2 December 2nd 04 05:55 PM Mark Excel Discussion (Misc queries) 0 November 25th 04 10:59 PM

All times are GMT +1. The time now is 10:23 AM.