ExcelBanter - How to convert date to YYQN

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to convert date to YYQN (https://www.excelbanter.com/excel-worksheet-functions/205567-how-convert-date-yyqn.html)

Christine[_3_]

How to convert date to YYQN

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

thanks

John C[_2_]

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

Gary''s Student

How to convert date to YYQN

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

--
Gary''s Student - gsnu2007k

"Christine" wrote:

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

thanks

John C[_2_]

How to convert date to YYQN

Please don't double post your questions.
--
John C

"Christine" wrote:

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

thanks

All times are GMT +1. The time now is 12:42 AM.