Sep 29, 2026, 2:46 AMI am now voluntarily using Excel to do date arithmetic.
I am here: https://en.wikipedia.org/wiki/Date_of_Easter#Gauss's_Easter_algorithm
- Sep 29, 2026, 2:46 AM
Replies
- Sep 29, 2026, 3:00 AM
I mean seriously, Gauss.
- Sep 29, 2026, 3:19 AM
What happens if Anzac Day falls on an Easter public holiday? Is it subsumed into it or is a consolation holiday added at the end? I have to find this out for four jurisdictions now.
- Sep 29, 2026, 4:01 AM
To calculate the date of the second Monday in a month:
=DATE(Y,M,13)-WEEKDAY(DATE(Y,M,13))+2
Where the 13 and 2 come from is left as an exercise for the reader.
- Sep 29, 2026, 6:22 AM
I have performed a three-table outer join in Excel. I am as a god, ask me anything.
- Sep 29, 2026, 6:50 AM
*Accidentally looks at the calculations for the Aotearoa New Zealand holiday of Matariki, is immediately humbled*
Malcolm Herbertmherbert@chinwag.orgSep 29, 2026, 6:55 AM@futzle ... ok, you have to post a link to that now
- Sep 29, 2026, 6:57 AM
@mherbert One of the references on the Wikipedia page: https://www.mbie.govt.nz/assets/matariki-dates-2022-to-2052-matariki-advisory-group.pdf
Best part is (paraphrased) "And then we move it to a Friday, because who wants to visit family in the middle of a work week?"
