Feb 07 2008

What Day Is Easter?

Published by at 7:03 pm under Bookmarks,General,Software

Have you ever wondered what day Easter is going to fall on?  Well so have I.  Wikipedia has been my source of this information for the last few years but it only gives you the date for the next 15 years or so.  What if you want to know when is the next time Easter is going to fall on March 23rd? (2160)

Having found a formula for calculating the date I threw together a spreadsheet and did a fill down.  Did you know that in the year 3000 Easter Sunday is going to be on April 13th?  That’s assuming Easter is still celebrated, the Gregorian calendar is still used or that humans still exist.

What’s more, I have been kind enough to publish this formula and data (until 3176 – until someone asks for more) on Google Spreadsheets at the following url:  http://spreadsheets.google.com/pub?key=prVVEmxcBM2cS0KU6TrF7cA

At some point I may add other useful associated dates to the spreadsheet, such as Shrove Tuesday & Ash Wednesday.

Tags: , , , , ,

3 responses so far

3 Responses to “What Day Is Easter?”

  1. # Dazon 16 Jan 2009 at 10:57 am

    Long winded!

    try this formula works in google docs!!!

    Easter sunday
    =FLOOR(DATE(C3,5,DAY(MINUTE(C3/38)/2+56)),7)-34
    Good Friday
    =FLOOR(DATE(C3,5,DAY(MINUTE(C3/38)/2+56)),7)-36
    Easter Monday
    =FLOOR(DATE(C3,5,DAY(MINUTE(C3/38)/2+56)),7)-33

    I use it to calculate british bank holidays

  2. # Dazon 16 Jan 2009 at 11:09 am

    Ash Wednesday
    =FLOOR(DATE(C3,5,DAY(MINUTE(C3/38)/2+56)),7)-80
    Shrove Tuesday
    =FLOOR(DATE(C3,5,DAY(MINUTE(C3/38)/2+56)),7)-81

  3. # gringodon 16 Jan 2009 at 11:19 am

    Hi Daz,

    Thanks for those formulae, I had completely forgotten about this post. When I get some spare time I’ll see about updating the spreadsheet.

Trackback URI | Comments RSS |

Leave a Reply