Creating Formula Multi-Select Field to Display Fiscal Years between 2 Dates
My dilemma is that I would like to create a formula multi-select field that shows which fiscal years the range between 2 dates contains.
For instance, our fiscal years are between Sept 1st and August 31, If I have a Start Date of 09/01/2018 and 07/01/2020, I would like the formula multi-select field to display that this range is in
------------------------------
Stephen
------------------------------
For instance, our fiscal years are between Sept 1st and August 31, If I have a Start Date of 09/01/2018 and 07/01/2020, I would like the formula multi-select field to display that this range is in
FY19 FY20 FY21.
My Initial thought was to somehow make a continuous if statement with the different Fiscal Year formulas, but I think that is inefficient. If anyone has any ideas I'd love to hear them.
------------------------------
Stephen
------------------------------