# SPO Calculate the difference between two dates

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula:

``````=DATEDIF([Column 1],[Column 2],"D")
``````

But when i trigger the calculated column in a flow and show the days calculated in an email it look likes for example: So what i should use in the formula to remove all the zeros ? Any help would be appreciated.

Thank you!

• What are your settings on the calculated field? Is it returning a number? And if so with how many decimals? – Johan Brännmar Nov 7 '19 at 11:08
• Yes in my list it's returning number without zeros, in the email it shows the zeros no idea why.Take a look here in my list: i.imgur.com/v4lslQd.png @JohanBrännmar – SmithBZ Nov 7 '19 at 11:15

## 2 Answers

Use the formula.

``````int(triggerBody()?['DateDif'])
`````` This question might help. The accepted answer says to just put your current column formula inside ROUND:

``````=ROUND([your formula here],0)
``````