WEEK_DELTA() : count the weeks between two dates

Used in a formula column, the WEEK_DELTA() function calculates the difference, in weeks, between two date-type columns. It measures a duration in weeks between two milestones: between order and delivery, between opening and closing a file.

Syntax

WEEK_DELTA(date_1, date_2)

Parameters

# Parameter Description

1 date_1 The more recent date (the result corresponds to date_1 minus date_2).

2 date_2 The reference date to subtract.

Examples

Count the weeks between two dates

The formula returns the number of weeks difference between the two dates.

WEEK_DELTA($End, $Start)

There are 6 weeks difference between April 1, 2022, and May 11, 2022.

There are 10 weeks difference between April 5, 2022, and June 16, 2022.

There are 19 weeks difference between February 8, 2022, and June 23, 2022.

The week count runs from Sunday to Monday.

Tip: for a difference relative to today, use WEEK_DELTA_TODAY() instead.

Go further

WEEK_DELTA_TODAY()

The same calculation, but relative to today.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.