In a formula column, the DAY_OPEN_DELTA() function allows you to subtract two date columns to display the result in days:

DAY_OPEN_DELTA = time1 - time2

However, unlike the DAY_DELTA() formula, the DAY_OPEN_DELTA() formula only counts working days, i.e. Saturday and Sunday are removed from the operation.

Formula

DAY_OPEN_DELTA(moment1, moment2)

Example

DAY_DELTA(Fin, Début)

Configurator

Result

There are 10 working days between Monday 4 April 2022 and Sunday 17 April 2022.

There are 5 working days between Thursday 7 April 2022 and Sunday 10 April 2022.

There are 0 working days between Saturday 9 April 2022 and Sunday 10 April 2022.