Formula to count dates by weekday in Excel

In fact, there are many cases need to use this formula to solve the problem! Suppose you have a row contains day have the event, and you want to count how many events on Monday!

Formula to count visible rows in a filtered list

You have a filtered list and want to count visible rows in this list. In Excel, you can use the SUBTOTAL function to do that. The formula will automatically ignore rows that are hidden by a filter.