Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

"Weeks Until" Formula?

Topic Labels: Formulas
117 3
Showing results for 
Search instead for 
Did you mean: 

I need a formula column to show weeks until a Due Date. I have a Due Date column, but I can’t figure out how to set up the formula column to calculate the number of weeks from today until the Due Date. And I need it to update continually.
Is this a possibility? Any advice on making this work? Thanks!

3 Replies 3
IF({Due Date}, DATETIME_DIFF(TODAY(), {Due Date}, "weeks"))

^ that, or swap the order of TODAY() and {Due Date}

Thank you Kamille! That worked perfectly. How can I add a unit so that instead of “9” landing in the column, it will say “9 weeks”?

IF({Due Date}, DATETIME_DIFF(TODAY(), {Due Date}, "weeks")  & " weeks")