OpenOffice Calc Tips

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!

This entry was posted on Wednesday, March 23rd, 2005 at 5:47 pm and is filed under Function Tips. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.