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!
"Weeks Until" Formula?
+27IF({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”?
+27Thank 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")
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.