Excel formula to increase cell quarter based on "seed" value in another column

[Brawnystaff]

I routinely get quarterly data reports and different times. However, the quarters themselves are not labeled in the spreadsheet. Rather, quarters are simply labeled as a single digit and are increase by a value of 1 each time a new quarter is listed. I find out what the first quarter is, and label each quarter accordingly.

I am looking for an Excel formula that would automatically give the quarter based on the "seed" value (e.g. if 1 is quarter 2013/1, then 5 would be quarter 2004/1).

Attached is a spreadsheet to illustrate by issue. Column A has the numeric value, Column B is the quarter formatted as I need it. I would like to copy a formula in Column B based on a the 'seed' value in cell B2. Any ideas? Thanks.

[samba_ravi]

b2=IF(A2="","",2013+INT((A2-1)/4)&"/"&MOD(A2-1,4)+1)
try this and copy towards down

[Brawnystaff]

Thanks nflsales. The only issues is that sometimes the 1st quarter number may not be the first quarter of the calendar year (e.g. 1 could be quarter 2013/3). Can the formula be adjusted to take that into account?

[samba_ravi]

In such case try =IF(A2="","",2013+INT((2+A2-1)/4)&"/"&MOD(2+A2-1,4)+1)

[Brawnystaff]

Excellent. Thank you so much.