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
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.
Or continue with
Formula glossary
All available operators and functions, sorted by category.