List quarters in row
Posted on 2011-09-14
I'm trying to automate some detail on my worksheet and I need to be able to enter the first quarter for a specific year and then have it list the quarters from that entry all the way through the last quarter of 2011.
Cell J13 = Q1-08 so I would want cell K13 to show Q2-08, etc. all the way through Q4-11.
I want to just enter the quarter/year in cell J13 and have it calculate the rest of the quarters automatically. This way I only have to enter the starting quarter and have the formulas do the rest.