Obtain Easter date?

G

Gabbon

Hi,
Probably a stupid question,
but does Excel contain any calendar functions that would enable me to create
a formula for obtaining the date of Easter each year?
Thanks.
 
P

Paul D. Simon

Here's an even easier formula to determine the date for Easter for a
particular year.

If you enter the year (say, 2006) into cell A1, then in B1 enter this
formula:

=DOLLAR(("4/"&A1)/7+MOD(19*MOD(A1,19)-7,30)*14%,)*7-6
 
Top