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?