Hello everyone, hope you had a fantastic new year!
How might I create a new column based on my date column, converting it into a financial year that commences in July ie. July 2023 → FY24, July 2024 → FY25, etc.
I hope I’ve understood the requirement correctly. There may be an easier way to do it with only using one field but I’ve had to use an equation and then a text forumula 
After discussing this with my (far more intelligent) wife, she pointed out my error. Hopefully, my second attempt will get you closer.
Check out the excellent Knowledge Base article on Ternary Operators
How to Get the Fiscal Year From a Date in Excel
Subscribe to my YouTube channel for more tips and tricks 
3 Likes
Works like a charm! Thanks @CarlHolmes, 
and to your far more intelligent wife <3
1 Like
Thanks for the feedback @RCB - it was a bit of a brain teaser 
1 Like