# 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.

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

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)

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!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1