Easter has passed for this year, but it’s never too early to figure out when Easter will occur next year. Then, you can book your vacation for that date, and be out of town when the family shows up for Easter dinner!
Last week, Excel MVP Jerry Latham showed us how to calculate distance in Excel, based on starting and ending points.
Today, Jerry explains how you can calculate Easter dates in Excel, using a worksheet formula or Excel User Defined Function (UDF).
First, Jerry gives a few examples of Excel worksheet formulas for Easter dates, where the year is entered in cell A1. This formula, by Norbert Hetterich, works if the regional settings have a day/month/year date format.
And here’s another Easter formula, by Thomas Jansen:
However, the worksheet formulas can’t be used reliably to determine dates of Easter after 2203, and the Hetterich formula fails for 2079.
Easter User Defined Functions
If you’re working with a limited range of years, one of the worksheet functions might be all that you need. However, for accuracy in a wider range of years, you can use an Excel UDF instead.
Jerry’s article includes 4 Excel UDFs for calculating Easter dates in Excel, and he has tested all the UDFs for speed and accuracy.
To use the UDFs, copy the code to your workbook, then type the function name in a worksheet formula, e.g.
Download the Easter Date Workbook
Visit the Excel Easter Date Calculation page on the Contextures website, where you can see the Easter formulas and UDFs, and copy them to your own workbook. Or, download Jerry’s sample file, and work with the code and formulas there.
If you have questions or comments, please let Jerry know. You can post a comment below, or send him an email at HelpFrom@JLathamSite.com