Excluding Weekends

  • Thread starter Thread starter Dave
  • Start date Start date
D

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?
 
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.
 
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
 
Back
Top