HI,
Can you please help me with the below as I've been racking my brain trying to figure it out.
I have two dates so take it as leave dates. I want to take these two dates i.e 3/1/2021 - 3/5/2021 and should on another table that for each day there was one employee taking off. Obviously if i have multiple employees taking over laping days the count needs to increase.
The Date range per employee is on the left. I want to reflect it in a date range on the right. Answer is on the right.
| | | | |
| SD 2 | 3/10/2021 | 3/15/2021 | | | 3/10/2021 | 2 |
| SD 4 | 3/10/2021 | 3/12/2021 | | | 3/11/2021 | 3 |
| SD 1 | 3/11/2021 | 3/15/2021 | | | 3/12/2021 | 3 |
| SD 8 | 3/15/2021 | 3/15/2021 | | | 3/13/2021 | 2 |
| SD 2 | 3/19/2021 | 3/22/2021 | | | 3/14/2021 | 2 |
| SD 8 | 3/19/2021 | 3/19/2021 | | | 3/15/2021 | 3 |
| SD 5 | 3/22/2021 | 3/28/2021 | | | 3/16/2021 | 0 |
| SD 1 | 3/29/2021 | 3/29/2021 | | | 3/17/2021 | 0 |
| SD 10 | 3/29/2021 | 4/2/2021 | | | 3/18/2021 | 0 |
