This is good one in that it tests out your ability to get the most out of the tools, as opposed to knowing which tools to use. As a beginner, it was relatively obvious which tools to use but putting them into practice effectively required me to develop a better understanding of alteryx syntax, particularly for the dates. Hopefully my solution can help others. Cheers.
Getting better at Date and Time handling, but I suspect there was a more direct way to handle this
[EDIT: Duh! Don't know why I didn't use the DateTime tool]