DAY_DELTA() : count calendar days between two dates

Used in a formula column, the DAY_DELTA() function calculates the difference, in calendar days, between two date-type columns, as a number. It is useful for measuring a duration or a delay: processing time for a request, age of a file, duration between order and delivery.

Syntax

DAY_DELTA(date_1, date_2)

Parameters

# Parameter Description

1 date_1 The more recent date (the result corresponds to date_1 minus date_2).

2 date_2 The reference date to subtract.

Examples

Count the days between two dates

To find out the number of days between a start date and an end date, the formula returns 7 when there is a 7-day difference between the two dates.

DAY_DELTA($End, $Start)

Tip: to track a delay in real time, replace date_1 with TODAY(): DAY_DELTA(TODAY(), $Opening Date) gives the current age.

Go further

DAY_OPEN_DELTA()

The same calculation, but in business days, excluding weekends.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.