Formula - rounding the formula results to less decimal points

I created a formula in my workflow within Monday, which brings the number of days from two dates, in the case TODAY (today) and a date of my business WARNING, see formula below:

DAYS (TODAY (), {AVISO})

It happens that the formula is bringing the result with non-whole numbers, with three digits after the comma… I need that form to show me only the whole number, without a fraction.

image

Can anyone help me in this demand?

@renato.rosa,

I had trouble with this one too. These will work…

If you want the result to be 0 when the date is blank:

ROUNDDOWN( 0 & DAYS(TODAY(),{AVISO})+0,0)

Or

IF({AVISO}<>"",ROUNDDOWN(DAYS(TODAY(),{AVISO}),0),0)

Otherwise:

IF({AVISO}<>"",ROUNDDOWN(DAYS(TODAY(),{AVISO}),0),"")
1 Like

Perfect !
Thank you very much for the help @JCorrell.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.