Workday() function - Analysis Toolpak

[MikeMelbourne]

Hello,

This is my first post on this forum. I am having difficulty with the Workday function in the Analysis Toolpak.

It's an ideal function for what I wish to achieve, and I can use it effectively in Excel.

For the life of me though, I can't seem to get it operating in VBA. I am attempting to call it from WorksheetFunction, but it doesn't appear in my list of properties, despite having both Toolpaks installed.

***EDIT - Solved. I had to go Tools->References and check the atpvbaen.xla addition. Workday functions now calling properly.
Unsure how to mark topic as solved.****

The task I wish to achieve is simple - add 4 working days to a given date. Presuming the date is in cell A1, the formula =Workday(A1,4) works a treat (disregarding holidays at the moment).

I believe that if the Analysis Toolpak - VBA is installed then Application.WorksheetFunction.WorkDay(arguments) should work - but it doesn't register?

When viewing Tools->AddIns in the VB editor nothing is displayed. Should the Toolpak show on this menu?

My VBA is 'developing'...it's been many years since I fiddled with code (Javascript as a child), and I can't seem to successfully replicate a WorkDay function with VBA. I'm close, but no cigar.

Does anybody have any suggestions? I'm all googled out.

Any help would be greatly appreciated.

Thanks,

Mike

[MikeMelbourne]

Sorry, I should have searched.
This article: http://www.cpearson.com/Excel/BetterWorkday.aspx looks like it will solve my headaches.

Responses still welcome - using the existing Workday function (or Networkdays) would be my preferred option.

Thanks,