Forum Discussion
SharePoint Online Date Calculation
I'd like to calculate the number of days between [today] and the due date in a SharePoint Online task list. Not sure why this seems so difficult or why I can't readily find an answer online. Any id...
Although Pavel Sheludkov already provided an answer, I just wanted to mention that view and column formatting now accept formulas that significantly shorten the expression.
In this case you would just write:
"=(Number([$DueDate])-Number(@now))/86400000"
Oh my gosh, Christophe! Thanks so much for your help and answer! Great to hear from you again. You helped me on some projects over three years ago!