Saturday Counting Trick
How to Calculate the Number of Saturdays in a Month Using Excel Formula

Learn how to count the number of Saturdays in any month with a simple Excel formula using SUMPRODUCT, TEXT, and EOMONTH functions.

Sundays in Excel
How to Calculate the Number of Sundays in a Month Using Excel Formula

Learn how to count Sundays in any month using a simple Excel formula with SUMPRODUCT, TEXT, and INDIRECT functions.