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

thanks

With date in A1

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

HTH. Best wishes Harald

"Christine" wrote in message
...
how to return a date to YYQN (eg 08Q1, 08Q2)?

thanks

Based on a calender quarter:

With a date in A1:

=TEXT(A1,"yy")&"Q"&CEILING(MONTH(A1)/3,1)

Based on today's date:

=TEXT(NOW(),"yy")&"Q"&CEILING(MONTH(NOW())/3,1)

--
Biff
Microsoft Excel MVP


"Christine" wrote in message
...
how to return a date to YYQN (eg 08Q1, 08Q2)?

thanks

Christine,
I dont know of a way to return the Quarter in a Custom Format, or any other.
However, there is a formula to use to do this yourself:

=IF(MONTH(A1)<10,IF(MONTH(A1)<7,IF(MONTH(A1)<4,TEX T(A1,"yy")&"Q1",TEXT(A1,"yy")&"Q2"),TEXT(A1,"yy")& "Q3"),TEXT(A1,"yy")&"Q4")

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Christine" wrote:

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

thanks

Please do not double post your questions.
--
John C


"Christine" wrote:

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

thanks