RE; invalid data type when adding Holidays
I am trying to add public holidays to a networkdays formulla. The formula works well when populated with dates, but display invalid data type when blank. see attached formulla and list of public holidays which i referenced from another sheet. any help would be grateful so that the invalid data not displayed.
Help Article Resources
Check out the Formula Handbook template!