Have you enabled the Analysis Tool Pak functions?

in the VBA Editor, go to Tools>References and enable atpvbaen.xls

Then the Analysis Tool Pak functions (including WORKDAY) would be enabled in the VBA Project for this workbook.