Thread: Identifying quarter to which a date belongs?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Identifying quarter to which a date belongs?
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

Reply With QuoteReply With Quote