The Calculating Easter post on John Walkenbach’s new Spreadsheet Page blog got me thinking. He presented a formula for calculating the date of Easter in a given year:
=DOLLAR((”4/”&A2)/7+MOD(19*MOD(A2,19)-7,30)*14%,)*7-6
 
Chip Pearson’s web site also has a couple formulas for calculating Easter:
=FLOOR(”5/”&DAY(MINUTE(A2/38)/2+56)&”/”&A2,7)-34

=FLOOR(DATE(A2,5,DAY(MINUTE(A2/38)/2+56)),7)-34
 
Chip also offers a UDF (VBA User Defined Function) which is valid through 2099, but breaks thereafter [...]