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.

## Comments

0 comments

Please sign in to leave a comment.