Want to get involved? We're always looking for ideas and content for Weekly Challenges.
This solution can handle any fiscal year end. You may define which month as the fiscal year end. The default month is defined in the Text Input tool.
One overly complicated formula later...
I used a Text input and some code that I found in the community for my solution!