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]

Re: Using NetWorkdays Worksheet Function

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 " <Bookreader127@ yahoo.com> wrote in message
news:smmvm1plab lf6g92kolpg9c7k 82vk6o0fk@4ax.c om...[color=blue]
>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.[/color]

[Bookreader]

Re: Using NetWorkdays Worksheet Function

On Mon, 7 Nov 2005 18:47:00 -0500, "Douglas J. Steele"
<NOSPAM_djsteel e@NOSPAM_canada .com> wrote:
[color=blue]
>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[/color]


Thanks. I will look at those tonight.

So, what does the NetWorkdays worksheet function do?

Thanks.

[Douglas J. Steele]

Re: Using NetWorkdays Worksheet Function

"Bookreader " <Bookreader127@ yahoo.com> wrote in message
news:g6qvm1ph00 kv1i1fd80irpg5t bkn433km4@4ax.c om...[color=blue]
> On Mon, 7 Nov 2005 18:47:00 -0500, "Douglas J. Steele"
> <NOSPAM_djsteel e@NOSPAM_canada .com> wrote:
>[color=green]
>>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[/color]
>
>
> Thanks. I will look at those tonight.
>
> So, what does the NetWorkdays worksheet function do?[/color]

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]

Re: Using NetWorkdays Worksheet Function

[color=blue]
>
>It's part of Excel, not Access. Unfortunately, they share a help file...[/color]

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

Thanks