Hello,
I'm trying to create a formula that will display a specific value if a date falls within a certain range. Any assistance would be greatly appreciated.
If “Target Update or Replacement Date” is between 10/01/20 and 09/30/21, then "Budget in Fiscal Year" = “FY 20-21”.
If “Target Update or Replacement Date” is between 10/01/21 and 09/30/22, then "Budget in Fiscal Year" = “FY 21-22”.
If “Target Update or Replacement Date” is between 10/01/22 and 09/30/23, then "Budget in Fiscal Year" = “FY 22-23”.
If “Target Update or Replacement Date” is between 10/01/23 and 09/30/24, then "Budget in Fiscal Year" = “FY 23-24”.
If “Target Update or Replacement Date” is between 10/01/24 and 09/30/25, then "Budget in Fiscal Year" = “FY 24-25”.
Note: The Target Update or Replacement Date is a date column, but the date it displays is being calculated by a formula.
