"Weeks Until" Formula?

Topic Labels: Formulas
858 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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")