On Jul 23, 3:54 pm, "T. Valko" wrote:
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- Hide quoted text -

- Show quoted text -


Works real well now, thanks to all those who posted.

Pierre