Net Work Days Calculation

L

lisa.conley

Is there a way to get the net work days between two dates in MS Access?
I know there is a NETWORKDAYS function in Excel and it seems there
should be an easy way to do this in Access. The DateDiff function
doesn't really work for me because I need to eliminate weekends.
Thanks in advance for any help.

-Lisa
 
P

Pieter Wijnen

Simple calendar query
select count(thedate) +sum(weekday(thedate)=1)+sum(weekday=7) from mytab
where thedate between startdate and enddate
should remove any weekends, needs to be ammended for public holidays though

hth
pieter

advanced math (as TRUE is -1 in VBA & american dates starts on sunday)
 
Top