Erroneous result when subtracting dates

Tim Dowden
Tim Dowden ✭✭
edited 03/20/22 in Formulas and Functions


I'm trying to find the # of days between 2 dates that are in separate, formatted as dates. I'm using a simple formula =([Start date]28 - [Finish date]23, )

The result seems fine when displayed with no decimals, - but if the decimals are shown, the results are wrong.

If the dates in the two cells are the same, the result is -0.375 If the dates are 1 day apart the result is 0.626

Can anyone explain this and suggest a better formula.



Best Answer

  • Tim Dowden
    Tim Dowden ✭✭
    Answer ✓

    Thank you for your suggestion Andree,

    I can implement your suggested work around, but the inability to correctly calculate a simple operation is surprising. 😒

    thanks again for your help



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!