Member Avatar for Hawkeye249

The following works to calculated the date for Easter any given year.

I don't understand why it works ...

=FLOOR.XCL("5/"&DAY(MINUTE(YEAR("1/1/2017")/38)/2+56)&"/"&YEAR("1/1/2017"),7)-34

I'm a novice - in the above, "1/1/2017" is used to provide a year. That could be done a number of ways,
and is not the same way I have the formula stored in a Libreoffice Calc spreadsheet.

  • 2 Contributors
  • 1 Reply
  • 385 Views
  • 5 Hours Discussion Span
  • Latest Post Latest Post by rproffitt
Member Avatar for rproffitt

Why not try this the other way? That is....

How would you find this date? That way you will understand the code your write.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.