Net Work Days in Access?

P

plh

Hello all,
Is there a way in access to obtains the difference in work days between two
dates, similar to DateDiff only excluding weekends (and holidays)? Excel has
this as NetWorkDays.
I have this column: EDays: DateDiff("d",[timein],[timeout])
Which works OK except that it includes weekends.
Thank You,
-plh
 

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

DateDiff 3
Can't query DateDiff 3
How to calculate # of work days inconjunction with datediff in Ac. 2
Date Difference Exclude Weekends 2
DateDiff function 3
Networkdays function in Access 7
adding work days to a begin date to derive the end date 1
Number of days 9

Top