Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution is longer because for some reason my brain thought part of it was having the workflow be able to translate the months for you (not writing out S=September, etc). I made this one harder for myself than it needed to be
I did pretty much the same as you but in a slightly compressed workflow by combining some of the steps. I still like it more than the many "ifs" on the months.
I wanted to do this in a way to avoid a long formula, but in all honesty I need practice with expressions so I followed along with original solution. One thing I didn't get was why there were AND statements for months of Jan,Jun,Jul and Apr,Aug, but not for not May, only Mar. Seemed excessive and inconsistent.
Used parse tool to get month into a different column.