Working days

Hi Paul,

Thank you for your question.

There is a function called NETWORKDAYS which allows you to work out the number of of working days between a start date and finish date and will also allow you to include any holidays taken. The Holiday argument is optional.

Here is an example:

=NETWORKDAYS(N2,O2,S2:S5)

N2 - Start Date
O2 - Finish Date
S2:S5 - Holiday dates range(in date format dd/mm/yyyy)

To access this function you need to enable the 'Analysis Toolpack' add-in.

1. Go to Tools and Add-Ins.
2. Check the box marked 'Analysis Toolpack' and click OK.
3. Then either type the function as outlined above or choose the function from the Insert Function dialogue box. It will be available under the Date and Time category.

I hope this answers your question.

Regards

Simon