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!!

[TABLE="width: 141"]
<TBODY>[TR]
[TD]</SPAN>
[/TD]
[TD]</SPAN>
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 106"]
<TBODY>[TR]
[TD="class: xl65, width: 77, bgcolor: #d9d9d9"]Launch Date
[/TD]
[TD="class: xl69, width: 64, bgcolor: #d9d9d9"]Year
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]4/25/13
[/TD]
[TD="class: xl67, bgcolor: transparent"]13Q2
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]7/18/14
[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q3
[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]11/3/14
[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q4
[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]2/1/2013
[/TD]
[TD="class: xl67, bgcolor: transparent"]13Q1
[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]6/1/2014
[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q2
[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[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!!

[TABLE="width: 141"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 106"]
<tbody>[TR]
[TD="class: xl65, width: 77, bgcolor: #d9d9d9"]Launch Date[/TD]
[TD="class: xl69, width: 64, bgcolor: #d9d9d9"]Year[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]4/25/13[/TD]
[TD="class: xl67, bgcolor: transparent"]13Q2[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]7/18/14[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q3[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 77, bgcolor: transparent"]11/3/14[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q4[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]2/1/2013[/TD]
[TD="class: xl67, bgcolor: transparent"]13Q1[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]6/1/2014[/TD]
[TD="class: xl67, bgcolor: transparent"]14Q2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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