Working Days_Start and End

  • Thread starter Thread starter Tim Loeffelholz
  • Start date Start date
T

Tim Loeffelholz

I am attempting to find the number of actualy working days
between StartDate and EndDate fields. I am able to use
DateDiff to get the actual number of days between these
two, but I'm not able to subtract Saturdays, Sundays, and
Holidays. Do I need to build another table that contains
the dates for Saturdays, Sundays, and Holidays, or does
Access/VBA have a Function that will do this for me? I'm
familiar with Networkdays in Excel, but can't find
anything similar in Access/VBA. Thanks in advance for
anyone's help.
 
Do a search. this is asked and answered alllll the time in these groups.

Rick B


I am attempting to find the number of actualy working days
between StartDate and EndDate fields. I am able to use
DateDiff to get the actual number of days between these
two, but I'm not able to subtract Saturdays, Sundays, and
Holidays. Do I need to build another table that contains
the dates for Saturdays, Sundays, and Holidays, or does
Access/VBA have a Function that will do this for me? I'm
familiar with Networkdays in Excel, but can't find
anything similar in Access/VBA. Thanks in advance for
anyone's help.
 
OK. How do I search through the group? I've never been
on this site before. Thanks again.
 
Back
Top