Finding Quarter between two dates

I believe I received assistance on this before in this forum, but it seems that my quarters have gotten out of whack. Our Fiscal Year begins on October 01. The dates for each quarter are as follows:

1st Qtr - (10-01-14 thru 12-31-14)
2nd Qtr - (1-01-15 thru 3-31-15)
3rd Qtr - (4-01-15 thru 6-30-15)
4th Qtr - (7-01-15 thru 9-30-15)

So if I enter a date in cell A1, cell A2 will give me the quarter.

Currently I have the below formula. Disregard the cell (F5), as I don't wish to confuse the example of cells A1 & A2 I wish to use. I cannot recall how the (FY_Start_Month) became a part of this equation, but in one cell I have a named range of (FY_Start_Month), and there is nothing in the cell, other than it being named that.

=MOD(CEILING(22-FY_Start_Month+MONTH(F5),3)/3,4)+1

Thanks

Just read forum rules, so hopefully I get this right on entering the formula so it can be examined more efficiently.

PHP Code: 

=MOD(CEILING(22-FY_Start_Month+MONTH(F5),3)/3,4)+1 


if A1 is your month

This formula will give your quarter

Please Login or Register  to view this content.

That helped mehmetcik, appreciate it!