# Share Point how calculate days in whole number

I'm using this formula in shapoint to calculate the difference between start date and due date. This formula is working very well, but when the approvals receive the automatic email about the Out of Office requests via Microsoft flow, the email shows Days off field as 5,00000000 instead of 5 only. I want to see the whole number. Number of decimal places is igual to zero into the share point setttings already. Not sure how to fixed it.

``````=SUM(IF(AND((WEEKDAY([Return Date],2))<(WEEKDAY([Start Date],2)),((WEEKDAY([Start Date],2))-(WEEKDAY([Return Date],2)))>1),(((DATEDIF([Start Date],[Return Date],"D")))-(FLOOR((DATEDIF([Start Date],[Return Date],"D"))/7,1)*2)-2),(((DATEDIF([Start Date],[Return Date],"D")))-(FLOOR((DATEDIF([Start Date],[Return Date],"D"))/7,1)*2))),1)*1-1
``````

## 1 Answer

You need to take care in MS flow, convert your decimal to integer or use substring function to truncate decimal places.

Below links would be useful.

• Hi, I found a simple formuma int()....inside the () we just need to include the column that we want and then it was solved...thanks for your comments. – Toni Bonato May 29 '19 at 11:31