Many thanks to all who've responded. It's great to know there are still
people out there willing to lend their expertise to learners like myself.

"T. Valko" wrote:

Hmmm...

I don't see Roger's reply in the thread but I see it quoted in your reply.

Try this:

Use the ordinal number to define the quarters. As the source for the drop
down use these:

1st Q (or Quarter)
2nd Q
3rd Q
4th Q

Then enter this formula in A2 and copy down to A4:

=TEXT((LEFT(A$1)*3-(ROWS(A2:A$4)-1))*30,"mmmm")

This will return the long month name like January. If you want the short
month name like Jan change "mmmm" to "mmm".


--
Biff
Microsoft Excel MVP


"suewho" wrote in message
...
I feel very blonde now....two great replies, but neither has worked!

"Roger Govier" wrote:

Hi Sue

Enter this formula in A2 and copy down through A3:A4
=TEXT(DATE(1,LEFT($A$1)+CHOOSE(LEFT($A$1),0,2,4,6) +ROW(A2)-1,1),"mmm")

--
Regards
Roger Govier

"suewho" wrote in message
...
In cell A1 I have created a list with options - 1st quarter results,
2nd
quarter results, 3rd quarter results, 4th quarter results.
Cells A2, A3 & A4 are for the months of the quarter.
If I select "1st quarter in A1", I want A2 to read "Jan", A3 to read
"Feb",
& A4 to read "Mar".
If I select 2nd quarter in A1, I want A2 to read "Apr", A3 to read
"May" &
A4 to read "Jun".....and so on thru the 3rd and 4th quarters.
I have investigated IF statements, but they don't work...

I'm so stuck. Is anyone able to help