Net Work Days Calculation

  • Thread starter Thread starter lisa.conley
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you calculate the Net Work Days in Access? 1
DateDiff to calculate work days 2
Date calculation 2
Calculate Working days ? 14
How do I calculate net working days in access 2003? 2
Access Functions 1
Net Work Days in Access? 1
No.f days between dates, no w/e and Fridays 2

Back
Top