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: Image

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? Commented Nov 7, 2019 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
    Commented Nov 7, 2019 at 11:15

2 Answers 2


Use the formula.


enter image description here


This question might help. The accepted answer says to just put your current column formula inside ROUND:

=ROUND([your formula here],0)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.