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

WEEK_DELTA_TODAY = week at time t - week of column

Formula

WEEK_DELTA_TODAY(colonne date)

Example

WEEK_DELTA_TODAY(Date)

Configurator

Result

The date is 8 April 2022.

For project 2, there is a 2 week gap between now and the Date column.