How to pass Access Column value in Holiday_array of Workday function in VBA?
<p>How to pass the MS Access table column value in MS Excel 2010 Workday function in range list of holidays.</p>

<p>I have following table.</p>

<pre><code>date_val
9/23/2016
9/24/2016
</code></pre>

<p>I want to use above list of dates in MS Excel 2010 Workday function in list of Holidays.</p>

<p>Example Workday(Today,addition of no of days, exclusion of Holidays)</p>

<p>As per above syntax of Workday function, I am looking
Workdays(Any Date, addition of one day, Exclude above listed MS Access Table column dates).</p>

<p>Can anyone assist how to pass MS Access Table column date value in holiday_array in Workday function?</p>

<p>Note : Code needs to implement in MS Access VBA environment.</p>