NETWORKDAYS to Calculate Duration
I need to calculate the duration between two dates. One of which happens to be in the future, however I didn't think that should matter. The screenshot below shows my data, and as you can see I am getting the #Invalid Data Type error, why I don't know why. My Duration column is set to text/number. And the second screenshot shows how my formula is structured. This is super easy to calculate in Excel, so I don't understand what I am doing wrong. I even reviewed the SS web page for this function, and I am still getting this error. Thanks in advance for your assistance.
=NETWORKDAYS([Plan / Develop - Start Date]1, [Plan / Develop - End Date]1)
Sherry Fox
Data Science & Reporting Specialist | PA Performance & Data Insights
UnitedHealth Group | OptumRx
EAP | Mobilizer | Automagician | Superstar | Community Champion
https://www.linkedin.com/in/sherryfox/
Answers
-
Double check that both date columns are in fact set as date type columns both in the sheet the formula is on as well as the sheet the dates are pulling from.
-
Yup, you were right. Both of those dates were text/number columns. I can only imagine this was a blonde moment that happened on a Monday before coffee! Thanks so much for your help. It never even dawned on me to make sure the dates were set to a date type!
Sherry Fox
Data Science & Reporting Specialist | PA Performance & Data Insights
UnitedHealth Group | OptumRx
EAP | Mobilizer | Automagician | Superstar | Community Champion
https://www.linkedin.com/in/sherryfox/
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!