NETWORKDAYS to Calculate Duration

Sherry Fox

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)

Paul Newcome

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.

Sherry Fox

@Paul Newcome ,

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!

Paul Newcome

Happy to help. 👍️