Count ALL days in a month, except Sunday

[mrsbrannon]

Hello,

Is there a quick way to count all days within a month leaving out only Sundays?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month Start Date[/TD]
[TD]Total Days Minus Sundays[/TD]
[/TR]
[TR]
[TD]1/1/2018[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thanks!

 

[Marcelo Branco]

Try

B2
=NETWORKDAYS.INTL(A2,EOMONTH(A2,0),11)

M.

 

[Jonmo1]

Which version of Excel are you using?
This is for XL2010+
Assuming A1 is the FIRST day of a given month

=NETWORKDAYS.INTL(A1,EOMONTH(A1,0),11)

 

[mrsbrannon]

That worked!! Thank you!

 

[Jonmo1]

You're welcome.