Hope you can help me on this issue.
I created a calculated column with the following formula to auto calculate the "Fiscal Quarter" based on the value in the "Date Of Review" column in my list.
=IF([Date of Review]<"10/1/2021","",IF(AND([Date of Review]>="10/1/2021",[Date of Review]<="12/31/2021"),"FY22_Q1",IF(AND([Date of Review]>"12/31/2021",[Date of Review]<="3/31/2022"),"FY22_Q2",IF(AND([Date of Review]>"3/31/2022",[Date of Review]<="6/31/2022"),"FY22_Q3","FY22_Q4"))))
The "Date Of Review" column is formatted as "mm/dd/yyyy", but when I added a value that is greater than "10/1/2021", for example, "2/23/2022", the calculated column always shows blank.