Getting a #Date Expected error using NETWORKDAYS and TODAY()
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!