Getting a #Date Expected error using NETWORKDAYS and TODAY()
Options
Umesh Shah
✭✭✭✭
I have a simple formula to calculate the number of days between a date and today.
But getting an error. Any ideas?
Tags:
Best Answer

Formula looks good @Umesh Shah
Have you set "Workdays Since CW" to be a "Date" column type? It should be "Text/Number", as the result of the formula is just a number, not a date. If you set it as a Date it will expect a date to be returned and your formula will not do that.
Answers

Formula looks good @Umesh Shah
Have you set "Workdays Since CW" to be a "Date" column type? It should be "Text/Number", as the result of the formula is just a number, not a date. If you set it as a Date it will expect a date to be returned and your formula will not do that.

Thank you, that worked.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!