Need to calculate number of days but only if there's an entry in both cells.


I have a formula to calculate the number of days between two cells (Date Filed and Date Resolved) but can't figure out a way to keep the #InvalidDataType message from showing if the matter is still open and there's no entry for Date Resolved yet.

You can ignore column 10 in the image. That's just me messing around trying to figure out a solution.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!