Access should also have the date function workingdays (mon-fri)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Like in Excel it would be handy if Access standard includes the function to
calculate the number of workingdays between two dates. On the internet I
found VBA codes to add this function, however it would be more easy to all
users if it would be a standard function in Access. Thank you!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9ee9-37cdf2da6d53&dg=microsoft.public.access
 
And there is also (but does NOT allow for holidays):

Compute the number of working days between two dates:

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


First datediff is total number of days between dates.
Second datediff is number of Saturdays between dates
Third datediff is number of Sundays between dates.

Ron
 
Back
Top