Subtracting Dates

Pamb10 ✭✭✭✭
edited 05/14/21 in Formulas and Functions

I have 2 date columns in my sheet. When I try to use the NETDAYS function I get #InvalidDataType.

Does this function work with date column types?

What am I doing wrong?

Incidentally, the Created column has a formula to lookup the created date.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!