+ Reply to Thread
Results 1 to 3 of 3

Countif Between 2 dates

  1. #1
    Registered User
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    49

    Countif Between 2 dates

    Here is my dilemma,

    I need to know how many dates in a range fall between 2 dates.

    For example, how many of the dates listed below fall between 11/4/2019 and 12/31/2019:

    Please Login or Register  to view this content.
    I am trying variations of countif functions I see posted elsewhere, but with no avail.
    I named the date range above to "PAY_PERIODS", and the locked cells in the formula below are going to be the start and end dates.

    Please Login or Register  to view this content.
    The formula does not work if the range is 1/1/2019 to 12/31/2019.

    Any help is appreciated,

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,223

    Re: Countif Between 2 dates

    I set up what you described and it works fine. How is your file different than this?
    Attached Files Attached Files
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  3. #3
    Registered User
    Join Date
    11-29-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    49

    Re: Countif Between 2 dates

    You know what, human error!!
    I was expecting to see the number of pay periods to jump to 26 if I used 1/1/2019 to 12/31/2019, but it would't, because there are only 6 in the "PAY_PERIODS"

    Silly error on my part, thank you for your help!

+ 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. [SOLVED] SUMIF and COUNTIF Between Dates with Cell References Dates Help
    By kschmit1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-14-2018, 10:51 AM
  2. COUNTIF using dates
    By bradleyandrewdavis in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2015, 01:45 PM
  3. COUNTIF function with Dates & due dates.
    By kcowper in forum Excel General
    Replies: 3
    Last Post: 03-10-2011, 12:51 AM
  4. CountIF Between 2 Dates
    By cakonopka in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-14-2007, 01:14 PM
  5. Countif using dates
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-06-2005, 09:05 PM
  6. Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. Countif using dates
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Tags for this Thread

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