Year for Broadcast Calendar

[Cadams2021]

Hi, I work for a TV media buying agency and we work off of a broadcast calendar It is VERY different than a standard calendar. (see attached).

We need to find the Broadcast QTR, Month & Year for any given date very regularly.
I was able to find formals to calculate the Broadcast QTR & Broadcast Month for any given date by using the following:

QTR: ="Q"&MOD(CEILING(MONTH(A2+7-WEEKDAY(A2,2)),3),13)/3
Month =TEXT(28*(MOD(MONTH(A2+7-WEEKDAY(A2,2))-1,12)+1),"mmmm")

Is there a formula to figure out the year?

 

[Tetra201]

Could you please provide examples of the formula not working (with the expected results)?