Thanks to both of you for your answers. One question: How do i get rid
of the little square box that appears after the word "Qtr", and the
year?

I assume that they are *non-printing* line break characters, Char(10).

Position the cursor in the formula bar where the line wraps and hit the
Delete button to remove each one.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Pierre" wrote in message
ps.com...
On Jul 23, 3:10 pm, John Bundy (remove) wrote:
Cut the month stuff off the end, that will fix ya

=("LABOR
MIDPOINT:"&CHOOSE(MONTH(D14),"1ST","1ST","1ST","2N D","2ND","2ND","3RD","3RD*","3RD","4TH","4TH","4TH ")&"QTR"&(YEAR(D14)))
--
-John
Please rate when your question is answered to help us and others know what
is helpful.



"Pierre" wrote:
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 -

Thanks to both of you for your answers. One question: How do i get rid
of the little square box that appears after the word "Qtr", and the
year?

Thanks again.

Pierre