I tried using the function belows
1. Function to help convert range to array from an exisiting file.
2. Function to include workday1 with the exceptions of holidays (as per covert rangetoarray)
The output i get when i use workday1 function is #VALUE .
Any help will be greatly appreciated...