Comment utiliser la formule NETWORKDAYS dans Google Sheets ?

In Google Sheets application, if we need to know the number of net working days between two specified dates, the NETWORKDAYS formula can be our companion.

Syntaxe

NETWORKDAYS(start_date, end_date, [holidays])

• date_début – the starting date in the period from which the formula calculates the number of net working days. This date, if not a holiday, is considered for counting as a working day.
• date_de_fin – the ending date in the period until which the formula calculates the number of net working days. Like date_début, this date too, if not a holiday, is considered for counting as a working day.
• holidays – is an optional parameter that expects either an array or an address reference to the range of cells that consists of holiday dates.

Usage: NETWORKDAYS Formula

Let us try our hands on this formula. Please consider the snapshot below. We have a sample list of holiday dates from A2 to A6.

Dans le premier exemple, le date_début et date_de_fin parameters take outputs from two different DATE() functions, evaluated to 15-Mar-2017 and 15-Apr-2017 respectively. And, we ignored the holiday’s parameter altogether. Therefore, the NETWORKDAYS formula calculates the resulting number of work days falling between the date_début et date_de_fin. It does so by ignoring the Saturdays and Sundays but does include the start and end dates

The second example is pretty similar. Except, the date_début et le date_de_finparameters are references to the cells that has dates. Also, we have given a range reference to the list of holidays for the third parameter. So it counts the net working days after ignoring Saturdays, Sundays, and the list of holidays that fall between the date_début et date_de_fin.

Unlike the previous two cases, the input values for date_début et date_de_finparameters are absolute numbers for the next two examples. Nevertheless, the formula’s working remains the same.

Cas d'intérêt

Poussons l'expérience un peu plus loin et saisissons des valeurs de date basées sur du texte pour la rubrique date_débutet date_début paramètre.

In the first example, the formula truncates the decimal values and uses only the integer values and accordingly evaluates the count. Of course, it cannot accept negative numbers, as there is no date interpretation for such values.

From the next two examples, we will see that the NETWORKDAYS formula accepts input date strings in the “dd-mmm-yyyy” and “mm-dd-yyyy” formats. But it will throw up an error with “dd-mm-yyyy” date format strings.

NETWORKDAYS formula

And there you go! Use the NETWORKDAYS formula in Google Sheets to calculate the number of net working days between two specified dates.

Si vous souhaitez en savoir plus sur les différentes formules de Google Sheets, nous vous invitons à consulter notre article de blog sur les formules de Google Sheets. Formule DAYS360 dans Google Sheets.

Vous pouvez également consulter les articles de blog qui s'y rapportent ci-dessous !