Find Quarter Month From Date In Excel

[Rick Rothstein]

Yes Rick, possible.

Another one with COUPNCD

=COUPNCD(A1,DATE(YEAR(A1),12,31),4,1)

format the cell.

Okay, if we are willing to let the Cell Format provide the month name (for display purposes only, I guess), then we can reduce the function down to only two function calls (the less function calls, the more efficient, right?)...

=1*(LOOKUP(MONTH(A1)+2,{3,6,9,12})&"/13")

and format the cell.