Forum Discussion
Count days from date range
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 manual...
Maride2225 See the attached.
first I assumed that the dates may be entered just as you said (or as a single date)
second I assumed you have the latest version of Excel (365 subscription)
So first I converted that mix of dates and text to 2 columns for start date and end date (columns C and D)
then I created a list of all possible dates from first to last and the corresponding count that particular date is found in any of those ranges (columns F and G)
then I filtered that table of all dates to show only the dates that have a count > 0 (columns I and J)
THEN I converted all of those helper columns into a single massive LET statement in M2 (i.e. you could delete all the other columns but I left them there to show the process I did)