Create fiscal year from a date (for example 2024/25)

Natasha D

Hi all

I have a date column and want to create a new column that transforms the dates into a fiscal year (January-December). For example:

20/8/25 will be represented as 2025/26

1/3/2027 will be represented as 2027/28

Basically, anything that that is in a calendar year (i.e: 2024) will be represented as 2024/25 and so on.

I have searched online but haven't been able to find anything to help me.

Thanks!

Hollie Green

=RIGHT(YEAR(Date@row), 4) + "/" + (VALUE(RIGHT(YEAR(Date@row), 2)) + 1)

Hollie Green

=RIGHT(YEAR(Date@row), 4) + "/" + (VALUE(RIGHT(YEAR(Date@row), 2)) + 1)

Natasha D

Thank you so much. That worked perfectly!