I thought this is easy but somehow I didn't get this right.
I entered the following formula in the calculated column but the outcome is incorrect.
For example, when [Target_Finish]=10/10/2019
, the column should return "FY20", but it returns "FY19".
=if([Target_Finish]="","",if([Target_Finish]<"9/30/2019","FY19",if(and([Target_Finish]>"9/30/2019",[Target_Finish]<"9/30/2020"),"FY20","FY21")))