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
Try this formula in cell C2:
=IF(COUNTIFS($E$2:$E$5,">="&A2,$E$2:$E$5,"<="&B2),"Yes","No")
Copy down as required.
Hope this helps.
Pete
how about
=COUNTIFS($E$2:$E$5,">="&A2,$E$2:$E$5,"<="&B2)
that will show a count depending on how many in the list it finds in the range
so add an IF() if you want to out put a YES or NO
=IF( COUNTIFS($E$2:$E$5,">="&A2,$E$2:$E$5,"<="&B2) , "Yes", "No")
as all your dates are included i changed 1
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
How aboutFormula:
Please Login or Register to view this content.
this is great!! thanks!!
you are welcome
Glad to help & thanks for the feedback
If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.
Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks