Results 1 to 8 of 8

Formula to see if Date Ranage contains a date from list

Threaded View

  1. #1
    Registered User
    Join Date
    01-02-2024
    Location
    Hawaii, USA
    MS-Off Ver
    Office 265
    Posts
    2

    Formula to see if Date Ranage contains a date from list

    Hi! I am trying to figure out how to do a formula to see if the date range of two dates contains any of the dates in a separate list of dates. Please see the example data below!! Thanks in advance!!!

    Start Date End Date Range Has a Date from Date list
    2/1/2023 2/5/2023
    1/17/2023 3/14/2023
    4/1/2023 6/13/2023


    Date List
    2/2/23
    5/17/23
    1/17/23
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date list to complete date list showing no-event-dates
    By Wimpietje in forum Excel General
    Replies: 8
    Last Post: 08-30-2023, 07:32 AM
  2. Replies: 3
    Last Post: 07-31-2019, 06:07 AM
  3. Replies: 4
    Last Post: 03-21-2018, 09:25 AM
  4. Replies: 7
    Last Post: 02-02-2017, 02:41 PM
  5. Replies: 5
    Last Post: 12-01-2015, 02:36 PM
  6. [SOLVED] Formula to compare date (including month and year) from a listed date to today's date
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2014, 05:31 PM
  7. how to extract latest date to a paticular date from diffrent date list
    By rudraalok in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2014, 05:18 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1