Excel: Determine working days with the "net working days" function

Thanks to the "net working days" formula, you can use Excel to calculate your working days. In this guide we show you step by step how exactly this works.

Determine working days in Excel with "net working days" - so it'll work

1. First enter your start of work in a field (see picture).
2. In the field below, enter the time when you finished working.
3. Now use the function "= NET WORKING DAYS" and enter the two fields with your working days.
4. Excel will then automatically calculate your working days and output them.
5. Note that Excel does not know public holidays. You must then define these separately and specify them at the end of the formula.

Tip: This is how you can password-protect an Excel file

In the next practical tip we will show you how you can calculate your overtime with Excel.