Count the Number of Saturdays and Sundays in Any Period in

This article provides a clear overview of Count the Number of Saturdays and Sundays in Any Period in, with the main facts, useful context, and practical details organized for easy reading.

Example

Example: For the following data table, calculate the number of Saturdays, Sundays, and Mondays.

There are 2 ways to calculate:

Method 1: Use the Weekday () Function.

1. Calculate the Number of Sundays

- In cell D5 enter the statement as shown. Similar to cop statements for the remaining cells in column D.

- Note: Make a table of corresponding values of the items in the table below. Sunday value = 1 so when comparing "= 1".

2. Calculate the Number of Days 7

- In cell E5 enter the statement as shown. Here day 7 has value = 7 so compare weekday () with value 7 -> Copy the formula for the remaining cells.

3. Calculate the Number of Days 2

In cell F5 enter the command as shown. Here the second value of 2 should compare Weekday () with value 2.

Result:

You can open the calendar to check.

Method 2: Use the Int () Function.

1. Calculate the Number of Sundays

- In cell E5 enter the statement as shown. Sunday here is 1 so subtraction 1.

2. Calculate the Number of Days 7

- In cell D5 enter the statement as shown. Here Saturday has a value of 7, so subtraction will subtract 7.

3. Calculate the Number of Days 2

- In cell F5 enter the command as shown. Monday has a value of 2 so subtract 2.

? Results calculated in 2 ways:

Note: You can calculate the number of days in any order, you just need to change the corresponding value of the item into the formula.