+ Reply to Thread
Results 1 to 4 of 4

Finding Quarter between two dates

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    49

    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. #2
    Registered User
    Join Date
    01-27-2014
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    49

    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)+

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Finding Quarter between two dates

    if A1 is your month

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

  4. #4
    Registered User
    Join Date
    01-27-2014
    Location
    Orlando
    MS-Off Ver
    Excel 2016
    Posts
    49

    Re: Finding Quarter between two dates

    That helped mehmetcik, appreciate it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help in finding start and End Quarter
    By eon13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2014, 11:00 AM
  2. Naming the Quarter between two dates
    By kjmosp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2014, 07:39 PM
  3. Finding year end applicable for each quarter
    By Amar Thakkar in forum Excel General
    Replies: 3
    Last Post: 10-21-2011, 04:53 AM
  4. Replies: 2
    Last Post: 05-22-2011, 06:54 PM
  5. Quarter between two dates ?
    By RAKESH230583 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-11-2009, 06:11 AM

Bookmarks

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