Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI liked this one ;)
I originally put the date parsing in the macro, but then decided to pull them out just in case the date formats changed. Turns out that move matched many of the solutions directly. The calculations around open and closed took some experimenting and validation to get right.