# Working with Quarters

1. ## Working with Quarters

If I have a column that shows a quarter, for example 1Q 2008, how can I add one quarter to it? So, I would like to add one quarter so it would be 2Q 2008. I get caught up with working with year end-- moving from 4Q 2007 to 1Q 2008.  Register To Reply

2. Not sure from your question what your after. If you want to drag 4Q 2007 down and have it change to 1Q 2008 this formula get you started in the right direction

=MOD(ROW(A1)-1,4)+1&"Q "&TEXT(INT(ROW(A4)/4)+7,"2000")
Starts at 1Q 2008

VBA Noob  Register To Reply

3. If A1 contains 1Q 2008 or similar and B1 contains the number of quarters to add (or subtract if negative) then this formula will give the relevant quarter

=MOD(LEFT(A1)+B1-1,4)+1&"Q "&INT((LEFT(A1)+B1-1)/4)+RIGHT(A1,4)  Register To Reply

4. Daddylonglegs, interesting formula. Have never seen that before-- thanks for sharing!

I did write up a few if statements to accomplish the same thing but I like your formula better.

VBA, looks similar to Daddy so thanks for sharing also!

Thanks!  Register To Reply