Forward & Backwards Quarters from an Entered Date

D

Danny

I need column names for quarters 4 quarters forward and 3 quarters backwards
along with the present from the an entered date as shown below:

3Qtr06 4Qtr06 1Qtr07 2Qtr07 3Qtr07 4Qtr07 1Qtr08 2Qtr08 3Qtr08

I believe the issue I am running into is leap years . Depending on the month
(which ends up being a first quarter or last quarter month that causes
issues), the most future quarter or the oldest quarter end up with the wrong
year. I ended up having the user enter the month & the year from two drop
downs. The reason I went to drop downs is that so I could set the actual day
of the month for both the year and the month to try to avoid the issue, with
no luck. I run out to 2012.

I ended up having the user enter the month & the year from two drop downs.

Here are some of the calculations that I am am using:

ROUNDUP(MONTH($F$3)/3,0)&"Qtr"&RIGHT((YEAR($F$4)),2) for present qtr
ROUNDUP(MONTH($F$3+91)/3,0)&"Qtr"&RIGHT((YEAR($F$4+91)),2) for 2qtr out
ROUNDUP(MONTH($F$3+182)/3,0)&"Qtr"&RIGHT((YEAR($F$4+182)),2) for 3 qtr out

Where $F$3 is the month and $f$4 is the year

Thanks for the help in advance,

Danny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top