1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Easter day formula.

    From David2me@21:1/5 to All on Sat Jan 11 11:56:22 2020
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)