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

[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

 

[Arvin Meyer [MVP]]

It is so easy to find, that it isn't necessary. You can also set a reference
to Excel and use the Excel function or, more easily, simply use this
function:

http://www.mvps.org/access/datetime/date0006.htm

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Ron2006]

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