Do you know when Easter is this year?

[Admin]

I found a shorter formula here

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

but it gives, incorrect results after year 2203

Also see The Date of Easter

[Rick Rothstein]

I found a shorter formula here

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

but it gives, incorrect results after year 2203

The DOLLAR function? 14%? Really? How do people manage to figure these things out (even with the year 2203 restriction)???

Also see The Date of Easter

Interesting... the algorithm in the article you cited is completely different from the underlying algorithm behind the code I posted, yet they both produce identical results. To be sure they produced identical results, I created a UDF from the article's "code" (inserting Int function calls where necessary) and compared results from my posted function and the new UDF for the years 1583 to 9999 and they both produced the same Easter date for each year.