Just posting this here because I use this all the time. It is simple, self-explanatory and it works. It takes a cell’s (B2) date and displays it as YYYY – Qx

=IF(MONTH(B2)=7, YEAR(B2) & " - Q" & 1 ,IF(MONTH(B2)=8, YEAR(B2) & " - Q" & 1 ,IF(MONTH(B2)=9, YEAR(B2) & " - Q" & 1 ,IF(MONTH(B2)=10, YEAR(B2) & " - Q" & 2 ,IF(MONTH(B2)=11, YEAR(B2) & " - Q" & 2 ,IF(MONTH(B2)=12, YEAR(B2) & " - Q" & 2 ,IF(MONTH(B2)=1, YEAR(B2) & " - Q" & 3 ,IF(MONTH(B2)=2, YEAR(B2) & " - Q" & 3 ,IF(MONTH(B2)=3, YEAR(B2) & " - Q" & 3 ,IF(MONTH(B2)=4, YEAR(B2) & " - Q" & 4 ,IF(MONTH(B2)=5, YEAR(B2) & " - Q" & 4 ,IF(MONTH(B2)=6, YEAR(B2) & " - Q" & 4))))))))))))

Advertisements