+ Reply to Thread
Results 1 to 2 of 2

Date Range between Variable Dates

  1. #1
    Registered User
    Join Date
    01-21-2022
    Location
    Tulsa, Oklahoma
    MS-Off Ver
    Not Sure
    Posts
    1

    Date Range between Variable Dates

    I am trying to create a formula to determine number of weeks between 2 days, but only including those days within a specified time period. For example, each row shows a start date and an end date, and I want to know how many of those days fall within a specified range. Here is an example,

    Start Date: 1/1/20
    End Date: 12/30/20
    Time Period: 4/3/20-8/3/20

    Start Date: 5/18/20
    End Date: 11/30/20
    Time Period: 4/3/20-8/3/20

    Start Date: 6/5/20
    End Date: 7/5/20
    Time Period: 4/3/20-8/3/20

    Start Date: 6/5/50
    End Date: 10/20/20
    Time Period: 4/3/20-8/3/20

    As you can see, I have multiple rows with a start date and an end date, and I am trying to determine how many days during the time period fall within the start date and the end date for each row. Any ideas? I know how to calculate days between events, but am not sure how to find how many days fall within the time period. Thank you!

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Date Range between Variable Dates

    There are instructions at the top of the page on how to post a sample sheet.Thanks

+ 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] SUM column based on two dates, SUM function begins at first date which is a variable
    By moxiepilot in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2013, 06:36 AM
  2. [SOLVED] Getting minimum and maximum dates from a variable length range
    By ianbhenderson73 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-13-2013, 12:25 PM
  3. [SOLVED] Return a variable based on a selection between dates and times in a range
    By Mr. H2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2013, 10:22 AM
  4. Replies: 8
    Last Post: 11-11-2012, 07:22 PM
  5. [SOLVED] Lookup values given a range of dates and variable name (difficult)
    By jongova in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2012, 04:13 PM
  6. Summing range of numbers according to variable dates
    By budapesh in forum Excel General
    Replies: 1
    Last Post: 05-26-2011, 05:46 PM
  7. Replies: 8
    Last Post: 02-27-2009, 06:06 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