Calculate Days from Today w/Rounding

Platform discussions Special workflows & use cases
1

Hi,

I have a field called “Entered Date”. I added a “Days Active” formula field and am trying to get it to show me the days between today and the entered date as a whole #.

When I use this:
DAYS(TODAY(), {Entered Date})

I get 1.857

Today is March 11th and the date in the field is March 10.

I entered today’s date into the date entered field and it said .857.

I tried these and got errors (these were suggested by copilot ai)
INT(TODAY() - {Entered Date})

IF(NOT(ISBLANK({Entered Date})), ROUND(TODAY() - {Entered Date}, 0), “”)

DATEDIF({Entered Date}, TODAY(), “D”)

Any idea how to round this appreopriately?

3

I tried ROUND(DAYS(TODAY(),{Entered Date}),0)

and it says a number but it’s wrong. I have entered date of today’s date and the days since field shows 1. I changed the entered date to yesterday and the days since field now says 2.

4

Hi @SYNrtucker,

Try:

ROUND(DAYS(TODAY(),{Entered Date}),0)-1

 

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

1 Like
5

Thank you. I ended up using a similar formula that worked:
ROUND(DAYS(TODAY(),{Entered Date})-1,0)