Perhaps an alternative to try:

Assuming dates are in col A, A1 down

Put in B1:

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

Copy B1 down

Col B will display what you want
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"sacredarms" wrote in message
...
How can I format a date 01/01/05 to show up as Qrt1, 04/01/05 to show up
as
Qrt2 and so on?
Any help appreciated.

Thanks