Used in a formula column, the DAY_DELTA_TODAY() function calculates the difference, in days, between today's date and a date-type column. It measures an age or a delay relative to today: ticket age, days remaining before a deadline.
The result changes over time. The calculation is based on today's date, so the displayed value updates automatically without needing to edit the formula.
Syntax
DAY_DELTA_TODAY(date_column)
Parameters
Examples
Calculate the difference with today
Today is April 8, 2022. For project 2, the formula returns a 12-day difference between today and the Date column.
DAY_DELTA_TODAY($Date)
Tip: combine DAY_DELTA_TODAY() with TERNARY CONDITION() to automatically flag delays (negative result) or upcoming deadlines.
Go further
DAY_DELTA()
Calculate the difference in days between any two dates, not just today.
Or continue with
Formula glossary
All available operators and functions, sorted by category.