ExcelBanter - Easter day formula.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Easter day formula. (https://www.excelbanter.com/excel-worksheet-functions/454540-re-easter-day-formula.html)

David2me

Easter day formula.

Thanks for the formula. Just a note for those looking to use the formula. The cell reference is for the year. A cut-n-paste formula for google sheets is :

=FLOOR("5/"&DAY(MINUTE(year(today())/38)/2+56)&"/"&year(today()),7)-34

It replaces the cell reference with the formula for the current year. An auto updating Easter formula.

All times are GMT +1. The time now is 04:03 PM.