Log In
Register
Home
New Member
July 14, 2021
Offline
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
July 16, 2010
Offline
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
1 Guest(s)
