Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHere's my solution!
Tried successfully using the LEFT and RIGHT formulas plus a DateTime tool. Then wanted to play catch-up with @TaraM's one formula solution and that worked too. The Help Index was an invaluable resource to see where "%Y%m%d" came from too.