Thanks for your answers - much appreciated.
I worked a way around it. My “Year 1” runs from anytime up to the 31st May 2022. Then years 2, 3, 4 etc run from 1st June to 31st May each year.
So I did a formula that deducts 6 months off the date, then took 21 off just the year value. A bit of concatenating after and I have Year 1, Year 2 etc.
A bit clunky - but works! I took a look at scripts - but this worked well.
Thanks so much again,