Skip to main content

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!

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

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

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

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

Reply


Terms & Conditions