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?
Solved! Go to Solution.
Hours(Today()-[Date Last Contact])/24 gives you the number of days.
Hours(Today()-[Date Last Contact])/24 gives you the number of days.
Thank you @Bellave_Jayaram
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |