Used in a formula column, the WEEK_DELTA_TODAY() function calculates the difference, in weeks, between today's date and a date-type column. It tracks deadlines in weeks: weeks remaining before a deadline, age of a file in weeks, alerts on tasks with approaching deadlines.
The result changes over time. The calculation corresponds to: week at time t minus week of the column. The result, expressed in weeks, is based on today's date, so it updates automatically over time.
Syntax
WEEK_DELTA_TODAY(date_column)
Parameters
Examples
Calculate the weekly difference with today
Today is April 8, 2022. For Project 2, the formula returns a 2-week difference between today and the Date column.
WEEK_DELTA_TODAY($Date)
Tip: combine WEEK_DELTA_TODAY() with TERNARY CONDITION() to turn the difference into a readable label (for example “upcoming,” “this week,” “past”).
Go further
WEEK_DELTA()
Calculate the difference in weeks between any two dates, not just today.
Or continue with
Formula glossary
All available operators and functions, sorted by category.