+ Reply to Thread
Results 1 to 2 of 2

Late count based on number of days between two dates for a list of dates

  1. #1
    Registered User
    Join Date
    12-07-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    26

    Late count based on number of days between two dates for a list of dates

    I have an index row above a row of dates.

    A1:E1 = 1,2,3,4,5
    A2:E2 = 1/3/17,1/10/17,1/19/17,1/25/17,2/3/17

    I need to get a late count of how many times there are >8 days between 2 dates.

    Is there a way to format the below formula into an array to test all dates?

    if(datedif(a2,b2,"D")>8,TRUE,FALSE)


    My thought process was to insert that function into a count function that counts the number of times this is true:

    countif(if(datedif(a2,b2,"D")>8,TRUE,FALSE),TRUE)


    However, I do not how to format this to operate on an array. I tried the below formula, but it did not work.

    countif(if(datedif(a2:d2,b2:e2,"D")>8,TRUE,FALSE),TRUE) CTRL+SHIFT+ENTER



    Any ideas on how to get this accomplished? Thanks.

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: Late count based on number of days between two dates for a list of dates

    Maybe try the following, array-entered with Ctrl + Shift + Enter?

    =SUM(IF((B2:E2)-(A2:D2)>8,1,0))
    Attached Files Attached Files

+ 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 formula to count the number days between dates
    By Barieq in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-04-2016, 05:16 PM
  2. [SOLVED] Count number of days between two dates, if the day is between 1-5
    By Randi20 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2013, 01:37 AM
  3. [SOLVED] Vlookup dates between two dates and count the number of days
    By nishikanth in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-28-2013, 03:25 AM
  4. Help on count the number of days in between dates and then average number of days
    By Barbara Excel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2013, 12:13 PM
  5. Count number of working days between two dates
    By dmucciolo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 02:22 AM
  6. Count number of days between 2 dates
    By Trueno in forum Excel General
    Replies: 14
    Last Post: 03-19-2009, 08:08 AM
  7. Count number of dates older than 30 days
    By altaquip_travis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-12-2008, 03:20 PM

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