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

  1. Type a start date in cell B18
  2. Type an end date in cell B19
  3. 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