# Finding Quarter between two dates

1. ## 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

2. ## Re: Finding Quarter between two dates

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  ```

3. ## Re: Finding Quarter between two dates

This formula will give your quarter
``Please Login or Register  to view this content.``

4. ## Re: Finding Quarter between two dates

That helped mehmetcik, appreciate it!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1