Count and visualize specific weekdays in a custom date range
The sheet demonstrated below let´s you type a custom date range and specific days. The calendar automatically counts and shows you selected days.
How to use
- Type a start date in cell B18
- Type an end date in cell B19
- Type a single or multiple weekdays (Mon to Sun) in cell range B20:B26
Download excel *.xlsx file
Count and visualize specific days in a custom date range.xlsx
Related posts:
Count specific weekdays in a date range
Excel: Count the number of a specific weekday in a range
Visualize date ranges in a calendar part 2
Create a custom date range in excel
How many of a specific weekday falls between a start date and an end date except holidays
Recommended categories
