The enumeration of the working days in Ms Excel

A very useful function for HR and payroll departments (of course, not only), when there is a need to settle employees and we need to calculate the number of days worked (free from holidays and weekends).

Function structure:

= working days ( 'start date', 'end date', 'holiday dates')

'start date' and 'end date ' - these are the cut-off dates between which we want to calculate the number of working days. Single cells should be indicated.

'dates of holidays' - this is a data area where all dates of "holidays" should be indicated, which we treat as non-working days. These can be religious or state holidays, employee vacation days, or departmental integration events and days after them :-)

An example of using the excel formula in practice: