Identifying quarter to which a date belongs?

H

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
 
B

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)
 
Top