Formulas - Numeros inteiros

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.