Creating Custom Date format Q1-2009, etc.

S

stef

Excel 2002 SP3
Win XP Pro SP2

Hi,

How do I properly create a Darte format that will display:

Q1-09
Q2-09
Q3-09
Q4-09
Q1-10
Q2-10
etc.?



Q is of course for Quarter so Q1-09 is Jan to Mar 2009.

Thanks!
 
B

Bob Phillips

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

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
S

stef

Bob,
Thanks but not what I need.
I need to define a custom date format that will render the desired format.
Not a formula that refers to the value, etc.
 
D

Dave Peterson

Can't be done with formatting.
Excel 2002 SP3
Win XP Pro SP2

Hi,

How do I properly create a Darte format that will display:

Q1-09
Q2-09
Q3-09
Q4-09
Q1-10
Q2-10
etc.?

Q is of course for Quarter so Q1-09 is Jan to Mar 2009.

Thanks!
Click to expand...
 

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 conditional sum in a matrix 6
Using VLOOKUP to draw data from two columns 5
MSAC2K - Form to select year and quarterly period for report... 5
VBA date in function 4
Custom date format 2
Can't access New External USB HDD to format 7
Custom Date Format Excel 2002 1
Custom Date Format 3

Top