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

edited 12/09/19 in Archived 2016 Posts
01/29/16 Edited 12/09/19

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?

Popular Tags:


  • J. Craig WilliamsJ. Craig Williams Top Contributor



    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.





This discussion has been closed.