In a formula column, the DAY_DELTA_TODAY() function allows you to subtract two date columns to display the result in days:

DAY_DELTA_TODAY = day at time t - day of the column

Formula

DAY_DELTA_TODAY(colonne date)

Example

DAY_DELTA_TODAY(Date)

Configurator

Result

The date is 8 April 2022.

For project 2, there is a 12-day difference between today and the Date column.