Between Formula???

[mcp201]

I wanted to know if there is a between formula. I have a set of data which is
sorted by division, fiscal month, sales, etc. I wanted to insert a formula
which displays quarter numbers if the fiscal month falls within that
criteria.

Example: Fiscal Period Month=7
If(A2 is <=3, display 1
If(A2 is <=6 display 2,

Thanks in advance.

 

[Mike H]

Maybe

=INT((MONTH(A2)-1)/3)+1

Mike

 

[Duke Carey]

maybe

=1+int(a2/3)

 

[Duke Carey]

Scratch that.

=ROUNDUP(A2/3,0)

maybe

=1+int(a2/3)