Month/Quarter - If Statement

[nymyth]

Hi team,

I am trying to do the following. I have a cell A1 that has a dropdown of months (jan, feb, mar...) and that has a name of 'date'.

In another tab I have a cell that I want the text to change depending on the month selected in the first tab.

So if Jan, Feb, Mar, or Apr is selected I want the text to return 'T1', if May, Jun, Jul, Aug is selected I want the text to return 'T2' and so on...

Is there a simple way to do this?

Thank you.

 

[nymyth]

I can't see the image (I'm at work) but your previous post referred to completely different cells. See if this is what you want:
=C3-INDIRECT(ADDRESS(13,ROUNDUP(MONTH(--("01-"&Date))/3,0)+1))

Flat out amazing...thanks a lot.