NETWORKDAYS using two different sets of holidays.
Hi,
Just wondering if its possible to use the NETWORKDAYS formula using two different sets of holidays, based on whether testing site is Munich or Sydney. I have the holiday dates listed in separate columns e.g
=IF([Testing Site]10="Munich", NETWORKDAYS(start_date,end_date,munichHol1:munichHol13), IF([Testing Site]10="Sydney", NETWORKDAYS(start_date,end_date,sydneyHol1:sydneyHol13))
When I try this formula I keep getting an error
Thanks
Comments
-
It is possible. Make sure you only have dates inside of the range you reference, and that they are formatted as date type. If you have a dynamic list, it might be better to use the collect formula to parse out any blanks or non-date numbers
-
Thanks for reply. Got it sorted!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives