I have a list of time off requests that are listed as date ranges (ie. 6/7/21 - 6/10/21 ) and I need to make a count of how many days off are requested for each date, ideally without having to manually input each date between the date ranges. So i want to be able to input
6/7/21 - 6/10/21
6/8/21 - 6/8/21
6/8/21 - 6/9/21
and be able to get a list
6/7/21 - 1
6/8/21 - 3
6/9/21 - 2
6/10/21 1
Hi Maride,
Welcome to our forum!
You will have to split the dates into separate columns. Then you can subtract the start date from the end date to calculate the number of days off. You can use Text to Columns to split the dates into their own columns, or if you're familiar with Power Query it can also split text. Here's an introduction to Power Query video.
Hope that points you in the right direction.
Myda
Hi Maride,
Here's a solution.
BR,
Lionel
