Hi Folks,
I am trying to create a formula that returns a result based on meeting specific parameters.
For example:
If Column A has a date range between 01/05/2025 and 30/04/2026 then enter FY26 into the cell.
If Column A has a date range between 01/05/2026 and 30/04/2027 then enter FY27 into the cell.
This is the formula I have come up with, to attempt to get one line working, but I am not having any luck for now.
IF({Contract Start Date}(<30/04/2025>01/05/2026)TEXT(FY26))
The column i am looking into is set as a calendar date range at the moment.