Reference text-formatted cell in date-formatted cell


Hello - trying to understand if there is a way to configure the WORKDAY function to allow the "num_days" piece of the formula to accept a reference to a text cell. Right now I am receiving the INVALID DATA TYPE error. Appreciate any assistance in producing the correct formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!