"Weeks Until" Formula?

[Moira_Krier]

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!

[Kamille_Parks]

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

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

[Moira_Krier]

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”?

[Kamille_Parks]

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