Thread: quarter
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default quarter
If you want the Q to display

="Q"&ROUNDUP(MONTH(A1)/3,0)

Mike


"Mike H" wrote:

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