Count specific day qty in date range.
I'm trying to write a formula to look at the range of dates (start date column and finish date column), and count how many Mondays, or Tuesdays etc are within that date range. Specifically I have 3 columns to calculate. How many week days (2, 3, 4, 5 or 6) are in the range; how many Saturdays (7) and how many Sundays (1) are in the range. I had a solution, but had to make a separate change and it broke my original method. I feel like there has to be a combination of If( or contains( or weekdays( etc.... but I can't figure it out. Any help is appreciated!!!
Help Article Resources
Check out the Formula Handbook template!