Supposing, I have the following two dates, and I need to count how many Sundays between them. Select a blank cell, enter below formula, and press the Enter key. And now you will get the number of Sundays between the two dates. See screenshot:

=INT((WEEKDAY($C$2- 1)-$C$2+$C3)/7)

Sometimes, you may need to count the total number of a certain weekday in the given month, says count the total number of Wednesday in July, 2020. Here, I will introduce a formula to count the total number of a certain weekday in the specified month easily.

Select a blank cell, type below formula, and press the Enter key to get the counting result.

=INT((WEEKDAY(DATE(G2,G3,1)- G4)-DATE(G2,G3,1)+EOMONTH(DATE(G2,G3,1),0))/7)

You can also create a User Defined Function to calculate how many specific weekdays in a given year and month besides the above formula.

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following code in the Module Window.

Public Function TotalDays(pYear As Integer, pMonth As Integer, pDay As Integer)
'Update 20140210
Dim xindex As Integer
Dim endDate As Integer
endDate = Day(DateSerial(pYear, pMonth + 1, 0))
For xindex = 1 To endDate
    If Weekday(DateSerial(pYear, pMonth, xindex)) = pDay Then
        TotalDays = TotalDays + 1
    End If
Next
End Function

3. Save this code and return to the worksheet, then in a blank cell, enter this formula = TotalDays(year, month, 1) . In this example, I will count how many Sundays there are in June 2020, so I can apply this formula as one of below formulas, then press Enter key, and you will get how many Sundays at once. see screenshots:

=TotalDays(C2,C3,C4)

=TotalDays(2020,6,1)

Notes: This formulas use integers to represent day of weeks: 1 is Sunday, 2 is Monday, 3 is Tuesday, 4 is Wednesday, 5 is Thursday, 6 is Friday and 7 is Saturday.

Actually, we can apply Kutools for Excel's Number of non-working days between two dates formula, Number of working days between two dates formula, and Count the number of specific weekday formula to quickly count the numbers of all weekends, weekends, or specific day of week in a date range in Excel.

1. Select a blank cell you will place the counting result, and click Kutools > Formula Helper > Formula Helper to enable this feature

And then go ahead based on your counting types.

A. Count the number of weekends (Saturday and Sunday) between two dates in Excel

In the Formulas Helper dialog, please do as follows:
(1) Select Statistical from the Formula Type drop-down list;
(2) Click to select Number of non-working days between two dates in the Choose a formula list box;
(3) Enter the start date in the Start Date box (you can also refer a date cell);
(4) Enter the end date in the End Date box (you can also refer a date cell);
(5) Click the OK button.

Now it returns the total number of all Saturdays and Sundays in the selected cell.

B. Count the number of weekdays (excluding Saturday and Sunday) between two dates in Excel

In the Formulas Helper dialog, please do as follows:
(1) Select Statistical from the Formula Type drop-down list;
(2) Click to select Number of working days between two dates in the Choose a formula list box;
(3) Enter the start date in the Start Date box (you can also refer a date cell);
(4) Enter the end date in the End Date box (you can also refer a date cell);
(5) Click the OK button.

And then it returns the total number of weekdays (excluding Saturdays and Sundays) in the selected cell.

C. Count the number of specific day of week (Monday, Saturday, Sunday, etc) between two dates in Excel

In the Formulas Helper dialog, please do as follows:
(1) Select Statistical from the Formula Type drop-down list;
(2) Click to select Count the number of specific weekday in the Choose a formula list box;
(3) Enter the start date in the Start Date box (you can also refer a date cell);
(4) Enter the end date in the End Date box (you can also refer a date cell);
(5) Specify the specific weekday with a integer (1 indicates Sunday, 2-5 means Monday to Friday, and 7 is Saturday.);
(6) Click the OK button.

And then it returns the total number of the specified weekday in the given date range.