IF THEN Formula?

[goldiekratz437]

Hi: I need to convert a date in one column to a text field. If the date is between 01/01/2013 and 03/31/2013 then the text would be 13Q1. If the date is between 04/01/2013 and 06/30/2013 then the text would be 13Q2. And so on. I'm trying not to manually do this. Thank you very much!!

</SPAN>	</SPAN>
Launch Date Year 4/25/13 13Q2 7/18/14 14Q3 11/3/14 14Q4 2/1/2013 13Q1 6/1/2014 14Q2 <TBODY> </TBODY>

<TBODY>
</TBODY>

 

[Sanjeev1976]

Hi: I need to convert a date in one column to a text field. If the date is between 01/01/2013 and 03/31/2013 then the text would be 13Q1. If the date is between 04/01/2013 and 06/30/2013 then the text would be 13Q2. And so on. I'm trying not to manually do this. Thank you very much!!

Launch Date Year 4/25/13 13Q2 7/18/14 14Q3 11/3/14 14Q4 2/1/2013 13Q1 6/1/2014 14Q2 <tbody> </tbody>

<tbody>
</tbody>

Try this :

=RIGHT(YEAR(A2),2)&"Q"&IF(AND(MONTH(A2)>=1,MONTH(A2)<=3),1,IF(AND(MONTH(A2)>=4,MONTH(A2)<=6),2,IF(AND(MONTH(A2)>=7,MONTH(A2)<=9),3,4)))

 

[njimack]

=TEXT(A1,"yy")&"Q"&ROUNDUP(MONTH(A1)/3,0)

Edit: Slightly shorter... =TEXT(A1,"yyQ")&ROUNDUP(MONTH(A1)/3,0)

 

[jimmy90]

Try this no If's needed.

=TEXT(A1,"yyQ")&ROUNDUP(MONTH(A1)/3,0)

Never mind got beat to it by njimack