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...
Pavel Sheludkov thank you for sharing this format. this works on my sharepoint list column. however, do you know how to remove the decimal points and just make it a round number of days?
Abbyamante , just use the floor() function to round the number down.
"=floor((Number([$DueDate])-Number(@now))/86400000)"