Format date as quarter-year

[PatrickO]

Using Excel 2003.

I have a Gantt chart developed, but I am strugling with a way to have the axis display the dates as Q3-2011 as opposed to the date as 10/1/2011.

I know that I can convert the date into a text version of Q3-2011, but I need to keep the date information intact to have my chart function properly.

Is there a way to format the date to display its respective quarter and year?

Thanks in advance.

 

[Weaver]

This is something I'd like to be able to achieve too, but I think it isn't going to happen.

 

[PatrickO]

I would be curious if there would be any way to use the custom number formatting to achieve this. From my understanding it can only incorporate basic logic, i.e. negative vs. positive.

 

[Matty]

Why wouldn't you just run a formula like:

="Q"&INT((MONTH(A1)+2)/3)&"-"&YEAR(A1)

And reference both the date Row and the quarter Row in your Chart?

Matty

 

[PatrickO]

How would you format the axis to show the corresponding quarter, but also hide the dates?

 

[Matty]

I think both elements would have to show.

Have you considered creating your Gantt Chart using Conditional Formatting?

Matty