Thread: quarter
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default quarter
Try

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

Mike

"Kent Prokopy" wrote:

How to display what quarter a date falls in?

03/24/2009 = "Q1"
Reply With QuoteReply With Quote