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.