Relevant Quarter

Hi

I have a date say 31/7/2008 and I need to return the relevant Quarter, can u help?

Thanks!

If that date were in cell A3, then the formula to find the quarter is:

=ROUNDUP(MONTH(A3)/3,0)

==============
If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

depends on when your first 1/4 is
this will give first quarter jan/feb/march
=INT(1+MOD(MONTH(A1)-1,12)/3)
and this if its apr/may/jun
=INT(1+MOD(MONTH(A1)-4,12)/3)