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
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
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
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!