I’m using this formula to count the number of days since a sales lead was last contacted.
Today()-[Date Last Contact]
The formula is plugged into the [Number Days] Column and is set to duration column type. The [Date Last Contact] column is set to Date column type.
The formula appears to be returning hours. I’m getting a result today (11/5/19) of 433:00:00 with a [Date Last Contact] date of October 18, 2019. 433/ 24 = 18 which would be the number of days since October 18.
What am I doing wrong?