Workdays

NETWORKDAYS(), the English version of NETWORKDAYS() returns the number of working days between two dates i.e. when counting holidays and weekends are not counted.

WORKDAY(), the English version WORKDAY(), returns the date separated by a specified number of working days forward or backward from the start date. Are not working days weekends and days identified as holidays. Holidays, the user must define themselves.

Suppose that the bill for the products you need to put only on working days, despite the delivery date. Write a formula that determines: if the delivery date falls on a weekend or holiday, then the invoice date is the following Monday (or last Friday). The decision also takes into account working Saturdays.

Suppose that the bill for the products you need to put only on working days, despite the delivery date. Write a formula that determines: if the delivery date falls on a weekend, then the invoice date is the following Monday (or last Friday).

Calculate the number of working days between two dates in case of non-standard work week: in

When planning the duration of performance of works are usually set in working days. The end date of the work can be calculated using the function WORKDAY().