Today() minus - "date of something that happened today" is negative

I am collecting (in a metric sheet) various dates of events that occurred either today or in the past. I am then calculating the duration since the event in days using =Today() - "the date collected".

When the date collected is today, then the result of the above formula is -1.

I assume this is because TODAY() is midnight, while the dates collected are after midnight.

Does anyone have a suggested workaround?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!