Hi,

I need a formula or Macro code to get period against Month and Quarter.
In the period first number "1" is common(we can ignore) and next two numbers are year and last tow numbers are month which is starting from Apr to end on Mar.

if the is period 10910 then Month will be APr-09 and Q Q1

For your understanding i have mentioned period against Month and Quarter


PERIOD Month Q
10901 Apr-09 Q1
11106 Sep-11 Q2
11307 Oct-13 Q3
11308 Nov-13 Q3
11301 Apr-13 Q1
11302 May-13 Q1
11303 Jun-13 Q1
11304 Jul-13 Q2
11305 Aug-13 Q2
11306 Sep-13 Q2
11307 Oct-13 Q3
11308 Nov-13 Q3
11309 Dec-13 Q3

Kindly help.

Regards

Prabhu