I am trying to calculate how many days it has been since a unit was paid for however I am getting the #INVALID DATA TYPE error. I am assuming the issue is that one of the dates I am referencing is pulling the date from a different sheet using a VLOOKUP formula. Is that the issue and is there a work around for it?

Any help is appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!