How to convert date to YYQN

[Christine]

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

thanks

 

[John C]

Date in A1.

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

Hope this helps.

 

[Gary''s Student]

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

 

[John C]

Please don't double post your questions.