« Data Consolidation 101 | Main | Rounding functions I »
March 23, 2005
Easter formula
Scanning the Excel boards for a formula for Easter that is easily ported to Openoffice Calc.=FLOOR("5/" & DAY(MINUTE(B5 / 38) / 2 + 56) & "/" & B5; 7) - 34 + 1
where B5 is the year we wish to find the date on which Easter (Sunday) falls.
This generates American date format MM/DD/YYYY and I believe it is valid to 2075 - which is long enough for me!
Posted by Dave at March 23, 2005 06:20 PM
Comments
Neat thanks. Where would you put the 40 day adjustment to figure out Mardi Gras?
Posted by: Bluie at March 24, 2005 06:23 PM
Dave, I thought your dates were wrong until I realised you have calculated Easter Monday rather than Sunday, but I get 'ERR 502'(invalid argument) when I copy from first cell. Tried putting $ on cell reference which gave me a date but it was wrong.
Posted by: kim at June 20, 2005 12:09 PM
This function is amazing though it has to be localized.
Using a german Date "DD.MM.YY" it works like this:
=FLOOR(DAY(MINUTE(A37 / 38) / 2 + 56)&".5." & A37;7)-34
Btw: Calc has a EASTERSUNDAY() function.
Compared with the builtin function there is one week difference in the year 2011. Your function returns 4/17/2011. The real easter sunday is 4/24/2011.
Posted by: Andreas Saeger at August 29, 2005 02:05 PM