Getting the month names for the first quarter

[navin]

Hi,

I have a sheet in which i have to display month names in a row based on
the quarter number selected from the drop down list.

Ex. if selected 1, then row should contain "Jan", "Feb" and "Mar".

Please help.

Thanks,
Navin

 

[Don Guillett]

You don't say which row
You don't say all in one cell or different columns and which

 

[navin]

What i meant was,

if Qtr: 1 is selected from the list then,

Row B2 should show "Jan", Row C2 should show "Feb" and Row D2 should
show "Mar"

Hope, i am clear this time.

Thanks for help.

Navin

 

[navin]

Thank you very much. This solved the issue. However, there is a little
change in this. quarter starts from Nov and not from Jan,

so selecting 1 should display

Nov Dec Jan as months, 2 quarter contains Feb, Mar Apr.

Any idea how to do this.

Thanks again.

Navin

 

[navin]

thank you very much. this did the trick


navin

Using my posted example....

Try this:
B1: =TEXT(DATE(2000,($A$1-1)*3-1,1),"mmm")
C1: =TEXT(DATE(2000,($A$1-1)*3-0,1),"mmm")
D1: =TEXT(DATE(2000,($A$1-1)*3+1,1),"mmm")

Does that help?
***********
Regards,
Ron

XL2002, WinXP