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 [...]

Last night a colleague complained because there was no way to evaluate a formula in the worksheet. What he meant was, he wanted to enter “m X + b” (for example, with numerical entries in place of m and b) into a cell, then link to another cell that contained a value of X, and [...]