View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David2me David2me is offline
external usenet poster
 
Posts: 1
Default 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.