Tom’s Tutorials For Excel: Calculating the Date for Easter
Easter (often referred to as Easter Sunday) is a Christian festival and holiday. Easter always falls on a Sunday, but its date varies depending on the calendar year and the phase of the moon.
Specifically, Easter falls on the first Sunday after the full moon following the northern hemisphere’s vernal equinox. In Western Christianity, Easter can fall as early as March 22 or as late as April 25.
Excel is the best spreadsheet application under the moon, sun, and stars, but it is not an astrological observation platform. However, Easter’s dates can still be returned with creative formulas, such as the one in the picture that lists the decade’s years in range A4:A13.
To calculate dates for Easter, the formula in cell B4 copied down to cell B13 is: