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"
Christophe Humbert is there any was to get the correct integer value of that 15 decimal number that is returned?
Christophe Humbert wrote:In this case you would just write:
"=(Number([$DueDate])-Number(@now))/86400000"
