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?

J. Craig Williams

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