How to count days with excluding Sundays and split by month in one?

[Efendi]

Hello Excel friends,

I would like to ask for a help:
Lets say there is a time period from 18/06/2016 till 20/12/2016. What I would need is to calculate:
- number of days for each month (June, July, Aug, Sep, Oct, Nov and Dec)
- with condition that Sundays are excluded

I tried to solve this using formulas, but with no result. Any idea please? Thank you, Marian

formula.jpg

[Jonmo1]

Try

=MAX(0,NETWORKDAYS.INTL(MAX($B$3,C7),MIN($C$3,EOMONTH(C7,0)),11))


FYI, formula for K3 could be
=NETWORKDAYS.INTL(B3,C3,11)

[Efendi]

Wau, thank you Jonmo for fast and so useful answer! NETWORDDAYS and NETWORKDAYS.INTL are new functions for me, never used before.

[Jonmo1]

You're welcome.

[Efendi]

Hello guys, I just found I would need additional help here please. Could you please advice how to change the formula so that it would exclude not only Sundays, but also some specific days, which are bank holiday in our country?
For example from the period 18/06/2016 - 20/12/2016, how to count number of days with excluding Sundays AND excluding 01/09/2016, 15/09/2016 and 01/11/2016. Thank you, Marian

[Jonmo1]

Make a list of the holidays to exclude in a range of cells, say $E$2:$E$20

=MAX(0,NETWORKDAYS.INTL(MAX($B$3,C7),MIN($C$3,EOMONTH(C7,0)),11,$E$2:$E$20))