Are these calendar quarters? If so, you can shorten that formula to:

="LABOR MIDPOINT: "&IF(D14="","",CHOOSE(INT((MONTH(D14)+2)/3),
"1ST","2ND","3RD","4TH")&" QTR "&YEAR(D14))

--
Biff
Microsoft Excel MVP


"Pierre" wrote in message
ups.com...
Formula trouble:


I have this formula in cell E15: =("LABOR MIDPOINT:
"&CHOOSE(MONTH(D14),"1ST","1ST","1ST","2ND","2ND", "2ND","3RD","3RD","3RD","4TH","4TH","4TH")&"
QTR "&(YEAR(D14)+(MONTH(D14)9)))


When I enter a date into D14, the formula result is usually the value
of D14's quarter, expressed as Labor Midpoint, the number of the
quarter, and the year.

However, when I enter 10/31/2008 into D14, it jumps to 3rd qtr, but
the "next" year, and not the current year of the value in D14.
10/31/2008 erroniously becomes "Labor Midpoint: 3rd Qtr 2009.

Any help troubleshooting would be appreciated.

Pierre