I have a need to calculate lead-times in business days rather than calender days. I've been fiddling around with the DateDiff() function, but it can't do business days. I think I found the best solution creating a UDF for a Microsoft-recommended DateDiffW() function.
I've done some VBA work in Excel before, but Access is a whole new game to me. Regardless, I have the code and now just need the steps to create the UDF. I think I have some of the steps, but not all of them...
Modules - New
Insert - ?Procedure?
and I got nothing from that point on...
Please help me identify the correct steps, as I need to be able to have this UDF for another query design.