Workday function

**Saky** · 01-28-2011, 12:15 PM

Hi friends,

Can anyone kindly help me.

I need a VBA function for a excel formula WORKDAY() .

Kindly help.

Saky

**smokebreak** · 01-28-2011, 01:31 PM

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.

**DonkeyOte** · 01-28-2011, 01:34 PM

If the ATP Add-In is activated in native XL you can also use via Evaluate call.

If you want to remove the ATP dependency altogether post back with your existing WORKDAY implementation - there are formula based alternatives (as well as VBA).

**Saky** · 01-31-2011, 09:20 AM

Guys,

I am using Microsoft Office excel 2003. I could not able to find the Analysis Tool Pak function atpvbaen.xls
in the references window. Couled you kindly advise me on this.

**dominicb** · 01-31-2011, 09:27 AM

Good afternoon Saky

Chip Pearson has an article on his site called "A Better Workday Function", along with code examples and an example workbook to download.

You can find it here.

HTH

DominicB

**Saky** · 01-31-2011, 09:56 AM

Hi Dominic,

Thanks for your help...But i am not looking for how to use WORKDAY function as i already have an article on how to use WORKDAY function. Thanks for sending me the document anyways.

I just want to know what add ins should be activated in my excel so that WORKDAY function will work in VBA window?

Thanks in advance.
Saky.