Count Quarters and Years from half way through the year (not calender year)

Guys,

Looking for a little bit of help.

Monthly cash flow
Say I have a monthly cash flow which starts from October 2012.
I want it to say in the cell below (looking at the dates above) that October 2012, November 2012 and December 2012 are Quarter 1 (not 4, as per the calender). Then, Jan, Feb and March 2014 would be 2...any ideas?

I mananged to solve this for years by using: =DATEDIF($A$1,A3,"y")+1

Count calender years

Slightly differently, can you count the calender years starting from my cash flow. So Oct, Nov and Dec 2012 = 1, then Jan, Feb etc = 2?

Thanks

For the quarters, this is a little ugly, but...

=IF(CEILING((MONTH(date))/3, 1) =4, 1, CEILING((MONTH(date))/3, 1) +1)



If you want "calender years since start", with the first year as year zero, woudn't that be something like,

=YEAR(start_date) - YEAR(assessment_date) +1

Suppose you have the start date of your accounting period in cell A1 (i.e. 1st October 2012), and other dates on the top row starting with C1 - then you can put this formula in C2:

="Q"&MOD(INT((MONTH(C1-$A$1+1463)-1)/3),12)+1

and copy it across. To get the relative year, you can put this formula in C3:

=YEAR(C1)-YEAR($A$1)+1

and copy that across.

Hope this helps.

Pete