SOLVED

# Count of date overlap

Copper Contributor

# Count of date overlap

Hi! I have a series of start dates and a series of end dates with an order number and location like the following

 Order Number Start Date Finish Date Location 1105 5/1/2023 5/20/2023 Location 1 1206 5/4/2023 5/16/2023 Location 1 1252 5/15/2023 5/18/2023 Location 1

I'm looking to account for all dates between the start and finish, and then get a count of how many orders overlap on each given day.

So in example with this data set 5/15/2023 would have a count of 3 orders active, and 5/17 would have a count of 2 active.

I would want to be able to find the largest count and how many days had that large of a number.

2 Replies
best response confirmed by SergeiBaklan (MVP)
Solution

# Re: Count of date overlap

See the attached workbook.

# Re: Count of date overlap

This is perfect, thank you so much! @HansVogelaar

1 best response

Accepted Solutions
best response confirmed by SergeiBaklan (MVP)
Solution

# Re: Count of date overlap

See the attached workbook.