I am trying to do a formula that shows how many days in between todays date and a date in a column.
I have this formula but the results show a decimal point. I just would like a whole number.
DAYS(TODAY(), {Last Communication})
Thank you!!!
I am trying to do a formula that shows how many days in between todays date and a date in a column.
I have this formula but the results show a decimal point. I just would like a whole number.
DAYS(TODAY(), {Last Communication})
Thank you!!!
Found the correct formula:
ROUND(DAYS(TODAY(),{Last Communication}),0)
Glad you found a solution. Just incase you want to count working days only you can use the WORKDAYS() function.
Thanks!
Mark