Date To Quarter, Plus Next 3 Quarters

[Guest]

I need to create 4 text labels in the format of qQyy (as in 4Q06).
I can easily determine the current quarter using the formula:

=ROUNDUP(MONTH(NOW())/3,0)&"Q"&RIGHT(YEAR(NOW()),2)
=4Q06

but I'm having trouble coming up with a formula to calculate the next 3
Quarters (1Q07, 2Q07, 3Q07) using the current date as the starting point.

I would greatly appreciate any help. Thanks.
Bob

 

[Guest]

Sorry, after I displayed my original post, I believe I have now come up with
the solution:

=ROUNDUP(MONTH((NOW())+91)/3,0)&"Q"&RIGHT(YEAR(NOW()+91),2)
=1Q07

=ROUNDUP(MONTH((NOW())+182)/3,0)&"Q"&RIGHT(YEAR(NOW()+182),2)
=2Q07

=ROUNDUP(MONTH((NOW())+273)/3,0)&"Q"&RIGHT(YEAR(NOW()+273),2)
=3Q07