I need it to report the QTR (Qtr 1, Qtr 2, Qtr 3 & Qtr 4) based on date, cant get all four to work correctly at same time. Is there a fix to my logic or a simpler way to do it?
=CONCATENATE(IF(MONTH(M9)>=4,"QTR 2",IF(MONTH(M9)>=7,"QTR 3",IF(MONTH(M9)>=10,"QTR 4","QTR 1")))& " FY"&YEAR(M9))
Answer should say : "QTR 2 FY2016" or similar based on date
Bookmarks