Reference text-formatted cell in date-formatted cell

Options

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.



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!