NETWORKDAYS Error

Mike B

I am getting the error #UNPARSEABLE

=NETWORKDAYs([Start Date]@row , [End Date]@row , [holidays])

Samuel Mueller

@Mike B "[holidays]" either has to be a range of dates or excluded completely.

=NETWORKDAYs([Start Date]@row , [End Date]@row)

=NETWORKDAYs([Start Date]@row , [End Date]@row, [holiday column]1:[holiday column]8)

=NETWORKDAYs([Start Date]@row , [End Date]@row, [holiday column]@row)

Mike B

Thanks!!!!

Samuel Mueller

No problem! I updated my last comment with additional examples as well