=IF(MONTH( Created )<=3," Q1 - "&(YEAR( Created )-1), IF(MONTH( Created )<=6," Q2 - "&(YEAR( Created )), IF(MONTH( Created )<=9," Q3 - "&(YEAR( Created )),IF(MONTH( Created )<=12," Q4 - "&(YEAR( Created )),"")))) Result: Created date : 21-01-2020 Output : Q4 - 2019 Consider FY : Apr to Mar