Using NetWorkdays Worksheet Function

[Bookreader]

I have a table that has a column for the number of workdays in the
month.

I found the NetWorkdays function and assumed that I could use it in an
update statement to calculate the number of workdays between two
dates.

This assumption turned out to be false.

So, how can I calculate the number of workdays between two dates in an
update? Or, how can I do it when I initially load the data in the
Datasheet view.

Thanks.

[Douglas J. Steele]

There are a couple of solutions in the Date/Time section of "The Access Web"
http://www.mvps.org/access

I also wrote about this in my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Bookreader" <Bo***********@yahoo.com> wrote in message
news:sm********************************@4ax.com...

I have a table that has a column for the number of workdays in the
month.

I found the NetWorkdays function and assumed that I could use it in an
update statement to calculate the number of workdays between two
dates.

This assumption turned out to be false.

So, how can I calculate the number of workdays between two dates in an
update? Or, how can I do it when I initially load the data in the
Datasheet view.

Thanks.

[Bookreader]

On Mon, 7 Nov 2005 18:47:00 -0500, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

There are a couple of solutions in the Date/Time section of "The Access Web"
http://www.mvps.org/access

I also wrote about this in my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

Thanks. I will look at those tonight.

So, what does the NetWorkdays worksheet function do?

Thanks.

[Douglas J. Steele]

"Bookreader" <Bo***********@yahoo.com> wrote in message
news:g6********************************@4ax.com...

On Mon, 7 Nov 2005 18:47:00 -0500, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

There are a couple of solutions in the Date/Time section of "The Access
Web"
http://www.mvps.org/access

I also wrote about this in my September, 2004 "Access Answers" column in
Pinnacle Publication's "Smart Access". You can download the column (and
sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

Thanks. I will look at those tonight.

So, what does the NetWorkdays worksheet function do?

It's part of Excel, not Access. Unfortunately, they share a help file...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

[Bookreader]

It's part of Excel, not Access. Unfortunately, they share a help file...

That explains a lot of things I've found in the help file.

Thanks