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.
