Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
function dates difference
POL GAM
✭
Hello there!
I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854
how can I obtain jus a round number of days?
Tags:
Comments
-
Pol,
I assume you have dependencies turned on. When you do that, {starting date] becomes a time-date, not just a date.
Try this:
=TODAY() - DATEONLY([starting date]3)
Hope this helps.
Craig
This discussion has been closed.