Convert date to yyQn

H

Harald Staff

With date in A1

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

HTH. Best wishes Harald
 
T

T. Valko

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)
 
T

Thomas [PBD]

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,TEXT(A1,"yy")&"Q1",TEXT(A1,"yy")&"Q2"),TEXT(A1,"yy")&"Q3"),TEXT(A1,"yy")&"Q4")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert date to YYQN 3
Repeated phrases wildcard? 1
How to change date format to 7 working days a week in ms project 2010? 0
Inserting slashes in dates in Excel 1
Text to date format 0
Formatting templates 7
Display weeks from a Milestone 0
Date Formats 4

Top