Identifying quarter to which a date belongs?

[harsh_njoy]

how to identify the quarter to which the following date belongs
'31/3/2007' in excel?

please let me know what function i should apply on the cell to get the
quarter. like in the above case answer comes out to be - 1.

Thanks,
Harsh

 

[Mike H]

Try

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

Mike

 

[Bob Phillips]

one less step

=INT((MONTH(A1)+2)/3)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[harsh_njoy]

Try

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

Mike

Thanks Mike





- Show quoted text -