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"
Wow, thank you for sharing Christophe Humbert. Now it looks really great, short and easy to read.