Monthly workdays, monthly workdays to date & public holidays

The last parameter in NETWORKDAYS is a user-defined range of Holiday dates.

Lo0k at the function help.

Originally Posted by JohnTopley

The last parameter in NETWORKDAYS is a user-defined range of Holiday dates.

Lo0k at the function help.

That's like asking my to look at French novel and translate it. I don't speak French.

So from what you're saying, I define public holiday dates in cells and then add that into the formula?

How?

... French lesson

=-NETWORKDAYS(A1,B1,C1:C8)

A1=Start Date
B1=End Date
C1:C8= List of UK holidays (as below)


01/01/2015
03/04/2015
06/04/2015
04/05/2015
25/05/2015
31/08/2015
25/12/2015
26/12/2015

OK?

Originally Posted by JohnTopley

... French lesson

=-NETWORKDAYS(A1,B1,C1:C8)

A1=Start Date
B1=End Date
C1:C8= List of UK holidays (as below)


01/01/2015
03/04/2015
06/04/2015
04/05/2015
25/05/2015
31/08/2015
25/12/2015
26/12/2015

OK?

Thanks.

It would be except I would then have to change the start and end date every month, yes? The current formula works off today's date so I don't have to do that. Surely I can amend the current formula to achieve the same but without having to define when the month starts and when it ends??

Yes, use your original formula but just add the C1:C8 (or equivalent) at the end

=NETWORKDAYS(EOMONTH(TODAY(),-1),EOMONTH(TODAY()-1,0),C1:C8)-1

Originally Posted by JohnTopley

Yes, use your original formula but just add the C1:C8 (or equivalent) at the end

=NETWORKDAYS(EOMONTH(TODAY(),-1),EOMONTH(TODAY()-1,0),C1:C8)-1

You are amazing thanks.. Kudos

Thanks for the feedback.

Please mark as SOLVED (Thread tools on top of first post).