Hi,
I have a formula to derive a fiscal year from a date but it presents the fiscal year as one year say 2021. Whereas I would like to be presented as 2021/22. The formula is = Year(B5)+MONTH(B5)>=C5) when B5 is the date and C5 is the start month. I suspect the answer might be in format - cells - custom perhaps?
Thanks
John
I have a formula to derive a fiscal year from a date but it presents the fiscal year as one year say 2021. Whereas I would like to be presented as 2021/22. The formula is = Year(B5)+MONTH(B5)>=C5) when B5 is the date and C5 is the start month. I suspect the answer might be in format - cells - custom perhaps?
Thanks
John