+ Reply to Thread
Results 1 to 2 of 2

Counting number of overlapping days between mulitple date ranges

  1. 07-26-2020, 02:36 PM #1
    cry04
    cry04 is offline
    Registered User
    Join Date
    11-05-2012
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    1

    Counting number of overlapping days between mulitple date ranges

    I need to calculate the number of overlapping days between multiple date ranges. Please see the attached workbook. Thanks in advance for your assistance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-26-2020, 06:37 PM #2
    teylyn
    teylyn is offline
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Counting number of overlapping days between mulitple date ranges

    Your question is not clear. In your data sample, please fill in the expected results, so we know what to aim for.
    Microsoft MVP
    http://www.teylyn.com
    Twitter: http://twitter.com/IngeborgNZ
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. [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. Counting the number of days in each month across two date ranges
    By ScottDAndersen in forum Excel General
    Replies: 3
    Last Post: 03-28-2019, 07:05 PM
  3. [SOLVED] counting number of days in overlapping date ranges
    By afgi in forum Excel General
    Replies: 11
    Last Post: 07-18-2018, 03:02 PM
  4. 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
  5. 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
  6. Summing # of overlapping days with lots of date ranges
    By tvnsf in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-08-2013, 01:48 PM
  7. Counting Continuous Days within overlapping Date Ranges
    By mgaworecki in forum Excel General
    Replies: 3
    Last Post: 09-07-2011, 08:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1