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

YEAR_DELTA_TODAY = year at time t - year of the column

Formula

YEAR_DELTA_TODAY(colonne date)

Example

YEAR_DELTA_TODAY(Date)

Configurator

Result

For project 3, there is a 3-year gap between now and the Date column.