Put in B1:


=IF(A1="","",VLOOKUP(MONTH(A1),{1,"Qtr1";4,"Qtr2"; 7,"Qtr3";10,"Qtr4"},2)&",
"&TEXT(A1,"mm/dd/yy"))

On 2nd reading, think the suggested formula was "overdone"
due to a slight over-interp of the orig. post <g

It should have been just in B1:

=IF(A1="","",VLOOKUP(MONTH(A1),{1,"Qtr1";4,"Qtr2"; 7,"Qtr3";10,"Qtr4"},2))

to return just: "Qtr1" or "Qtr2", etc

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----