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

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!