DAY_OPEN_DELTA() : count business days between two dates (excluding weekends)

Used in a formula column, the DAY_OPEN_DELTA() function calculates the difference, in business days, between two date-type columns, excluding weekends. It measures a processing time in working days: SLA compliance, response time excluding weekends, actual duration of a service.

Syntax

DAY_OPEN_DELTA(date_1, date_2)

Parameters

# Parameter Description

1 date_1 The more recent date (the result corresponds to date_1 minus date_2, in business days).

2 date_2 The reference date to subtract.

Examples

Count the business days between two dates

The formula returns the number of business days between the two dates, excluding weekends.

DAY_OPEN_DELTA($End, $Start)

There are 10 business days difference between Monday, April 4, 2022, and Sunday, April 17, 2022.

There are 5 business days difference between Thursday, April 7, 2022, and Sunday, April 10, 2022.

There are 0 business days difference between Saturday, April 9, 2022, and Sunday, April 10, 2022.

Tip: use DAY_OPEN_DELTA() instead of DAY_DELTA() whenever a duration is expressed in working days, so weekends are not counted.

Go further

DAY_DELTA()

The same calculation, but in calendar days, weekends included.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.