Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Attaching my solution
I'm gonna assume here that the DateTime tool worked differently back then:
Here is my solution to the challenge.
Not sure why this needs to be a macro....single formula tool solves this easily.
Attached is my solution.