I cover it pretty thoroughly in my Advanced DateTime Seminar. However, if you'd like me to put together a short TechHelp video on it, I would be happy to. The function doesn't exist in Access, so I had to write one.

Yes please I think this function is very useful for Project Managment.  I'm always looking at dates and adding bad weather days to get a start date and end date.  Then I add work hours to get the budget for the project.  This will be a most useful function in my line of work. No rush I know you have plenty on your plate to do
Thanks you Richard.  
V/r
Juan

Good Day ALL...
I got it to work about 98% of the time.  Here is what I did made a form and two fileds Startdate, EndDate.  
Dim daysworked As Long
Dim D1 As Date, D2 As Date
If StartDate  "" Then
D1 = Forms!projectlisting![StartDate]
D2 = Forms!projectlisting![EndDate]
Else
Exit Sub
End If

daysworked = myNetWorkDays(D1, D2)


StartDate = ""
EndDate = ""

if I pick a date that starts on Sun and ends on Sat I get 5 net days...  If I pick a Tue and end on Thu I get 2 days.  What did I do wrong?  If I work Tue, Wed and Thu that's 3 days.
Any feedback will be appreciated.

V/r
Juan

Yeah, that should work fine. I'll take a look at it when I make the TechHelp video. You're on the list.

Big Thanks I have done leap and bound with this channel.  Big Thanks for the continued support.

V/r
Juan