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.