Networkdays.intl

[UFGATORS]

I have a facility that operates 6-days a week Mon - Saturday. I need to be able to calculate the net workdays. In cell L2 is the month. For the normal workweek Mon-Friday I have the following formula "=NETWORKDAYS(L2,EOMONTH(L2,0))". Reading about the NETWORKDAYS.INTL I see you can designate the number of days in a workweek but I can't figure it out. Thanks

 

[mabalo76]

check the below link:
https://www.techonthenet.com/excel/formulas/networkdays_intl.php

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

 

[Rick Rothstein]

I have a facility that operates 6-days a week Mon - Saturday. I need to be able to calculate the net workdays. In cell L2 is the month. For the normal workweek Mon-Friday I have the following formula "=NETWORKDAYS(L2,EOMONTH(L2,0))". Reading about the NETWORKDAYS.INTL I see you can designate the number of days in a workweek but I can't figure it out. Thanks

You can add a third argument that tells it what your workdays are (use 0) and what your weekends are (use 1). So, for six workdays a week with Sundays off, you would use this as the third argument... "0000001". So, using the formula you posted, try changing it to this...

=NETWORKDAYS(L2,EOMONTH(L2,0),"0000001")

 

[Marcelo Branco]

Rick,

I think it should be
=NETWORKDAYS.INTL(L2,EOMONTH(L2,0),"0000001")

M.

 

[Rick Rothstein]

Rick,

I think it should be
=NETWORKDAYS.INTL(L2,EOMONTH(L2,0),"0000001")

Heh..heh, yeah, of course it should.

Thanks for catching that.

Note to self... watch what you copy/paste more carefully!

 

[UFGATORS]

Thank you.

 

[UFGATORS]

Thanks again Marcelo.

 

[UFGATORS]

That simple, I was aware of using 11, but I could not figure where to place it. Thank you.