Results 1 to 16 of 16

find Sum of # of days w/o counting overlapping days twice with multiple paramaters

Threaded View

civ1979 find Sum of # of days w/o... 05-09-2016, 04:55 PM
mehmetcik Re: find Sum of # of days w/o... 05-09-2016, 06:22 PM
civ1979 Re: find Sum of # of days w/o... 05-09-2016, 11:23 PM
civ1979 Re: find Sum of # of days w/o... 05-09-2016, 11:20 PM
FlameRetired Re: find Sum of # of days w/o... 05-16-2016, 03:12 PM
civ1979 Re: find Sum of # of days w/o... 06-06-2016, 12:45 PM
mehmetcik Re: find Sum of # of days w/o... 05-10-2016, 10:36 AM
FlameRetired Re: find Sum of # of days w/o... 06-06-2016, 01:50 PM
FlameRetired Re: find Sum of # of days w/o... 06-06-2016, 02:38 PM
civ1979 Re: find Sum of # of days w/o... 06-06-2016, 02:58 PM
FlameRetired Re: find Sum of # of days w/o... 06-06-2016, 03:03 PM
civ1979 Re: find Sum of # of days w/o... 06-06-2016, 03:07 PM
FlameRetired Re: find Sum of # of days w/o... 06-06-2016, 08:31 PM
civ1979 Re: find Sum of # of days w/o... 06-06-2016, 10:23 PM
FlameRetired Re: find Sum of # of days w/o... 06-07-2016, 08:51 PM
millz Re: find Sum of # of days w/o... 06-17-2016, 01:59 AM
  1. 06-06-2016, 08:31 PM #13
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: find Sum of # of days w/o counting overlapping days twice with multiple paramaters

    civ1979,

    I finally resorted to laying out parallel time lines.

    I get 103 for Reference# *1205083, duplicate dates counting as 1.

    Would you double check that 99 figure you have?
    Last edited by FlameRetired; 06-06-2016 at 08:35 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find number of overlapping days per person
    By maryjane84 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2016, 12:46 PM
  2. [SOLVED] How to find Sum of # of days w/o counting overlapping days twice
    By lanksout in forum Excel General
    Replies: 18
    Last Post: 08-11-2015, 02:15 AM
  3. Count number of overlapping days in multiple date ranges
    By tarsonis in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 05-08-2015, 03:22 PM
  4. [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
  5. Counting and summing the total number of overlapping days in two periods
    By kylienut in forum Excel General
    Replies: 0
    Last Post: 07-30-2012, 04:51 PM
  6. Counting Continuous Days within overlapping Date Ranges
    By mgaworecki in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 08:33 AM
  7. Counting the days worked and days remaining on a schedule automatically
    By uhcord98 in forum Excel General
    Replies: 9
    Last Post: 09-03-2007, 08:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1