Results 1 to 19 of 19

How to find Sum of # of days w/o counting overlapping days twice

Threaded View

lanksout How to find Sum of # of days... 08-09-2015, 05:36 PM
quekbc Re: How to find Sum of # of... 08-09-2015, 07:49 PM
lanksout Re: How to find Sum of # of... 08-09-2015, 09:32 PM
quekbc Re: How to find Sum of # of... 08-09-2015, 10:03 PM
lanksout Re: How to find Sum of # of... 08-09-2015, 10:57 PM
quekbc Re: How to find Sum of # of... 08-09-2015, 11:19 PM
FlameRetired Re: How to find Sum of # of... 08-09-2015, 11:36 PM
lanksout Re: How to find Sum of # of... 08-10-2015, 11:06 AM
lanksout Re: How to find Sum of # of... 08-10-2015, 12:21 PM
FlameRetired Re: How to find Sum of # of... 08-10-2015, 01:14 PM
lanksout Re: How to find Sum of # of... 08-11-2015, 12:19 AM
lanksout Re: How to find Sum of # of... 08-11-2015, 12:25 AM
FlameRetired Re: How to find Sum of # of... 08-11-2015, 01:03 AM
lanksout Re: How to find Sum of # of... 08-11-2015, 01:12 AM
quekbc Re: How to find Sum of # of... 08-10-2015, 05:59 PM
FlameRetired Re: How to find Sum of # of... 08-10-2015, 07:01 PM
quekbc Re: How to find Sum of # of... 08-11-2015, 12:55 AM
lanksout Re: How to find Sum of # of... 08-11-2015, 01:10 AM
quekbc Re: How to find Sum of # of... 08-11-2015, 02:15 AM
  1. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,708

    Re: How to find Sum of # of days w/o counting overlapping days twice

    Yes this is interesting and challenging. Arrived at a different approach.


    Row\Col
    A
    B
    C
    D
    E
    1
    Start End
    2
    **1/6/2015
    1/10/2015
    0
    0
    Array-entered C2 : {=SUM(IF(FREQUENCY(ROW(INDIRECT($A2&":"&$B2)),IFERROR(ROW(INDIRECT($A1&":"&$B1)),0))=1,1,0))+$C1}
    3
    **1/13/2015
    1/20/2015
    0
    0
    D2 : =SUM($C$2:$C2)
    4
    **1/12/2015
    1/22/2015
    7
    7
    5
    **1/18/2015
    1/25/2015
    12
    19
    Last edited by FlameRetired; 08-09-2015 at 11:38 PM.
    Dave

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculating # of Overlapping days with several date ranges and conditions
    By ZafferAhmed in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-30-2021, 05:44 AM
  2. [SOLVED] Find days between days, but including the starting date.
    By Jocamo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2015, 10:37 PM
  3. Calculating # of Overlapping days with several date ranges.
    By CarlSVM in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-06-2014, 07:09 AM
  4. Replies: 0
    Last Post: 07-30-2012, 04:51 PM
  5. Counting Continuous Days within overlapping Date Ranges
    By mgaworecki in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 08:33 AM
  6. Replies: 9
    Last Post: 09-03-2007, 08:26 PM
  7. [SOLVED] Dividing a time span into shifts - overlapping days
    By Heidi in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 02-27-2006, 10:14 PM

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