Calc workdays without NETWORKDAY

**troyakaTB** · 07-05-2011, 02:14 PM

I am building a template to use to calculate workdays for a long term substitute teacher. I originally used NETWORKDAY but this did not include specific school district off days.

I want to enter a start date and an end date and have it return the correct days of work to be paid correctly.

Any suggestions? Thanks in advance.

**Paul** · 07-05-2011, 02:48 PM

Hi TroyakaTB, welcome to the forum.

You can use NETWORKDAYS, but be sure to utilize the final argument in the function (called "holidays"). This argument can specify a range of cells that contain a list of dates that you consider "holidays" - or any other day you deem non-working.

See the Excel Help file for an example (or search this forum, as there are many).

Hope that helps!