G Guest Dec 27, 2004 #1 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?
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?
G Guest Dec 27, 2004 #3 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
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
B Barbara Wiseman Dec 28, 2004 #4 Dadgum, Chip Pearson has a good section on dates & times including Easter http://www.cpearson.com/excel/holidays.htm#Easter Barbara
Dadgum, Chip Pearson has a good section on dates & times including Easter http://www.cpearson.com/excel/holidays.htm#Easter Barbara
