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?

Month Start Date	Total Days Minus Sundays
1/1/2018	27

<tbody>
</tbody>

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.