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

Try

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

Mike

"harsh_njoy" wrote:

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

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" wrote in message
...
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

On Jul 25, 12:29*pm, Mike H wrote:
Try

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

Mike

Thanks Mike

"harsh_njoy" wrote:
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- Hide quoted text -

- Show quoted text -