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.
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.