Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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?
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