Excluding Weekends

[Dave]

I have a query that calculates the total days elapsed from
a beginning date to an end date using the DateDiff
function. This counts weekends, but I need to exclude the
weekend days from the calculation. Is there a function in
Access similar to the NETWORKDAYS in Excel which
automatically excludes Saturdays and Sundays or another
way that I can exclude the weekend days from the
calculation?

 

[Michel Walsh]

Hi,


Take a look at http://www.mvps.org/access/datetime/date0012.htm,
there is a function that can even take into account the holidays.


Hoping it may help,
Vanderghast, Access MVP

 

[Malcolm]

May be oversimple, but if you are just wanting to remove
all weekends couldn't you do DATEDIFF then multiply by 5/7?

May not be a precise result though.

 

[Michel Walsh]

From March 15 to March 26, there are 10 week days, 12 real days, your
formula gives 8.57

From 19 to 22, 4 real days, 2 week days, your formula returns 2.857


Vanderghast, Access MVP