Create formula to enter Specific info based on data range.

Platform discussions
,
1

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.

2

Here is a generic formula that will work for any date:

"FY" & 
RIGHT(
  IF(
    MONTH({Contract Start Date}) >= 5,
    YEAR({Contract Start Date}) + 1,
    YEAR({Contract Start Date})
  ) & "",
  2
)

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday