WORKDAY function

[enfantter]

is there a shortway to use the workday (excel)function i a userform?? based on textboxes??


Jack

[Bob Phillips]

Set a reference to the ATPVBAEN project, and then just call it as a normal VBA function.

[enfantter]

im not familiar with this, how does it work??

[Bob Phillips]

In the VBIDE, go to Tools>Refernces.

Scroll down the list until you find atpvbaen.xls and check it.

Then in the code use something like



MsgBox Format(workday(Date, 12), "dd mmm yyyy")