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
The date is 8 April 2022.
For project 2, there is a 2 week gap between now and the Date column.
Please sign in to leave a comment.