Creating Custom Date format Q1-2009, etc.

  • Thread starter Thread starter stef
  • Start date Start date
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!
 
="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)
 
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.
 
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...
 
Back
Top