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.
Can anyone help me in this demand?
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),"")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.