Formula Help - Count the number of days from a specific date but exclude Sundays

[easybpw]

Good morning and thanks in advance for the help.

Is there a formula that could count the number of days in the month your in but exclude Sundays? For example, today is 8/20/2020 so the number would be 20 but if we exclude the 3 Sunday's we've had so far this month the number would be 17. Is this possible?

 

[VBE313]

Calculate the count of workdays between two dates using VBA in Microsoft Excel

In this article, we will create a User Defined Function (UDF) to count the number of working days between the specified dates, including or excluding Saturdays and Sundays as week offs. Raw data for this example consists of a start … Continue reading →

www.exceltip.com

Here is a code that has optional InclSaturdays and InclSundays

Assuming your start date is in Cell A1 and your end date is in Cell B1, your formula would look like this

=CountWorkingDays(A1,B1,TRUE,FALSE)

Option Explicit
'THIS IS NOT MY CODE, GOT THIS FROM https://www.exceltip.com/custom-functions/calculate-the-count-of-workdays-between-two-dates-using-vba-in-microsoft-excel.html
Function CountWorkingDays(StartDate As Long, EndDate As Long, Optional InclSaturdays As Boolean = True, _
    Optional InclSundays As Boolean = True)

'Declaring variables
Dim RngFind As Range
Dim i As Long

For i = StartDate To EndDate
   
    On Error Resume Next
   
    'Finding the location where the specified date exist in the Holidays sheet
    Set RngFind = Worksheets("Holidays").Columns(1).Find(i)
   
    On Error GoTo 0
   
    'Checking whether it is holiday on the given date
    If Not RngFind Is Nothing Then
        GoTo ForLast
    End If
   
    'Checking whether it is Saturday on given date
    If InclSaturdays Then
        If Weekday(i, 2) = 6 Then
            GoTo ForLast
        End If
    End If
   
    'Checking whether it is Sunday on given date
    If InclSundays Then
        If Weekday(i, 2) = 7 Then
            GoTo ForLast
        End If
    End If
   
    CountWorkingDays = CountWorkingDays + 1
   
ForLast:

Next

End Function

 

[Fluff]

How about
=NETWORKDAYS.INTL(EOMONTH(TODAY(),-1)+1,TODAY(),11)

 

[AhoyNC]

Here is a formula option.

Book1
	A	B
1	Start Date	End Dare
2	8/1/2020	8/20/2020
3
4		17
Sheet2

Cell Formulas
Range	Formula
B4	B4	=NETWORKDAYS.INTL(A2,B2,"1000000")

 

[easybpw]

Thanks everyone! Great responses and great website!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Dave Patton]

Check Excel's help for the function.
Either of the following are correct.

T202008c.xlsm
	A	B	C
1	Start	End
2	01-08-20	20-08-20	17
3	01-08-20	20-08-20	17
2c

Cell Formulas
Range	Formula
C2	C2	=NETWORKDAYS.INTL(A2,B2,"0000001")
C3	C3	=NETWORKDAYS.INTL(A3,B3,11)