Then why are you complaining about my post about loading the analysis toolpak?

I didn't see a response from the OP that would answer your question and remove
the ambiguity.

Tyro wrote:

Because he said he wanted to count the number of days between two dates,
subtraction, and then used NETWORKDAYS in his formula. That is why I asked:
which one do you want?

Tyro

"Dave Peterson" wrote in message
...
If you are certain what the original intent was, why post your first
response:

Are you trying to count the number of days between the two dates or the
number of workdays?




Tyro wrote:

The OP said he wanted to count the days between two dates. It's simple
subtraction, not NETWORKDAYS,

"Dave Peterson" wrote in message
...
i tried
=NETWORKDAYS(B2,A2) but got #NAME?

=Networkdays() does require the analysis toolpak in xl2003 and below.

I wasn't addressing what formula to use.

Tyro wrote:

"i have two dates shown above in dates format and i would like to
count
the
days between those dates."

Does not require the installation of the Analysis Toolpak.

Tyro

"Dave Peterson" wrote in message
...
You have to install the analysis toolpak.

Tools|Addins|check Analysis Toolpak

If it's not listed there, you'll have to install it from the Office
CD.

doyree wrote:

please help!!

A B
01/28/08 02/03/08

i have two dates shown above in dates format and i would like to
count
the
days between those dates.

i tried
=NETWORKDAYS(B2,A2) but got #NAME?

can someone please help?

thank you!

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson

--

Dave Peterson