Count days excluding Saturdays

[Gman]

I think this should be easy but I cannot seem to wrap my head around it. Is there an easy way to count the number of days in the current month but exclude Saturdays? For example (3/1/17-3/14/17)-(2 Saturdays) = 12.

 

[Mike86]

WORKDAY.INTL with a weekend setting of 17 should help you out.

 

[bosco_yip]

Try,

=NETWORKDAYS.INTL("3/1/17","3/14/17",17)

Regards

 

[Gman]

Thank you... Works like a charm.