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.
Help Article Resources
Check out the Formula Handbook template!