Thread: How to convert date to YYQN
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default How to convert date to YYQN
Date in A1.

=TEXT(A1,"yy")&"Q"&INT((MONTH(A1)+2)/3)

Hope this helps.
--
John C


"Christine" wrote:

how to return a date to YYQN (eg 08Q1, 08Q2)?

thanks



Reply With QuoteReply With Quote