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

DAY_DELTA = time1 - time2

The formula takes into account the difference of one week from Sunday to Monday.

Formula

WEEK_DELTA(moment1, moment2)

Example

WEEK_DELTA(Début, Fin)

There is a 6-week gap between 1 April 2022 and 11 May 2022.

There is a 10 week gap between 5 April 2022 and 16 June 2022.

There is a 19-week gap between 8 February 2022 and 23 June 2022.

A week is counted from Sunday to Monday.