How to check if a date is in the current quarter

[chucktizzle]

I'm trying to create a formula to check if the value in column I is within the current quarter and return with a 1(true) or 2(false). The formula needs to update automatically based on the current date.

This is the formula I'm using to check if the value is in the current month:
=IF(AND(YEAR(TODAY())=YEAR(I2),MONTH(TODAY())=MONTH(I2)),1,2)

I cannot figure out how to test for the current quarter. Thanks!

 

[BobUmlas]

=if(int((month(today())+2)/3)=int((month(i2)+2)/3),1,2)

 

[VBA Geek]

Excel 2013
	A	B
1	02/10/2014	1
Sheet1

<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B1</th><td style="text-align:left">=IF(<font color="Blue">(<font color="Red">INT(<font color="Green">(<font color="Purple">MONTH(<font color="Teal">A1</font>)-1</font>)/3</font>)+1</font>)=(<font color="Red">INT(<font color="Green">(<font color="Purple">MONTH(<font color="Teal">TODAY(<font color="#FF00FF"></font>)</font>)-1</font>)/3</font>)+1</font>),1,2</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Dantrith]

=IF((MONTH(NOW())-MONTH(I2))<3,1,2)

Does that do it?

looks like I took too long! and the other answers are better

 

[chucktizzle]

Thanks! This works for the quarter part. I just had to add an AND operator to include a check for the current year, but works great.

 

[chucktizzle]

This is close and is actually where I was getting hung up. This only checks to see if the date is within the last three months, not to see if it is in the current quarter. Thanks for the reply, though!

 

[Vidar]

If the quarter should also be within the same year as today then try this:
=IF(AND(CEILING(MONTH(I2),3)/3=CEILING(MONTH(TODAY()),3)/3,YEAR(I2)=YEAR(TODAY())),1,2)

edit: just noticed post #5