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.