Spreadsheets: When is Easter?

The tutor points out how a spreadsheet can show holiday awareness.

Most holidays, such as Valentine’s Day, Halloween, or Christmas, happen on a set date. However, Easter is different. As a child, I overheard it’s the Sunday after the first full moon after the first day of spring. Hence, its date varies by year.

If you’re using the spreadsheet LibreOffice Calc, however, you don’t need to wonder Easter Sunday’s date; in a cell, just type

=eastersunday(year)

then hit Enter. The date of the given year’s Easter Sunday will show in the cell.

For instance,

=eastersunday(2016)

returns the date 2016-03-27.

Happy Easter:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Tagged with: , ,

Leave a Reply