Determining # of Week Days between Two Dates

  • Thread starter Thread starter LA Lawyer
  • Start date Start date
L

LA Lawyer

I want to calculate the difference of WEEK days (not including weekends)
between two dates. How is that done?
 
Here is a simple solution (watch word wrap):

1) Compute the number of working days between two dates:

workdays =DateDiff("d",[StartDate],[EndDate])-(DateDiff("ww",
[StartDate],[EndDate
],7)+DateDiff("ww",[StartDate],[EndDate],1)) + 1

The first datediff gives you ALL days, The second datediff gives you
the count of Saturdays. The third datediff gives you the count of
Sundays.

Add one of don't add one to the count depending on whether you want to
count the first AND last day or not.

You now have the total number of weekdays between two dates.

If you want to exclude holidays................
2) Create a table of holidays.

write a query that selects all records in that table between the
specified dates and use

holidaycnt= dCount ("[fieldnameinholidaytable]",
"theabovecreatedquery")

Subtract 2 from1 and you have the actual workdays. (Add 1 to result if
first and last day are to be counted)

Ron
 
Back
Top