I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. The formula is returning the #NAME? error in the cell.
However when she sent the spreadsheet to me the formula works correctly.
Here's the formula:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1,0))-J10-J11-J12

The formula is used to determine the number of available shipping days in a
month minus planned shutdown days, etc.

Why does the formula work on one computer and not the other???

Hi mp,

She will need to install the Analysis Toolpack.

Go to Tools + Addins + Check Analysis Toolpak.

Judith
--
Hope this helps


"mp" wrote:

I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. The formula is returning the #NAME? error in the cell.
However when she sent the spreadsheet to me the formula works correctly.
Here's the formula:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1,0))-J10-J11-J12

The formula is used to determine the number of available shipping days in a
month minus planned shutdown days, etc.

Why does the formula work on one computer and not the other???

If you check XL Help for NETWORKDAYS, you will see that this is part
of the Analysis ToolPak which needs to be installed for XL versions
2003 and earlier (it is built-in with XL2007).

So, get your colleague to install the ATP (details in XL Help) and it
should be okay.

Hope this helps.

Pete

On Aug 25, 2:41*pm, mp wrote:
I have a spreadsheet that I sent to a collegeau who is having difficulty with
one of the formulas. *The formula is returning the #NAME? error in the cell. *
However when she sent the spreadsheet to me the formula works correctly. *
Here's the formula: *
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1*,0))-J10-J11-J12

The formula is used to determine the number of available shipping days in a
month minus planned shutdown days, etc.

Why does the formula work on one computer and not the other???

Here's an alternative that doesn't depend on the Analysis ToolPak add-in.

=SUM(INT((WEEKDAY(DATE(YEAR(TODAY()),MONTH(J1),1)-{1,2,3,4,5},2)+DATE(YEAR(TODAY()),MONTH(J1)+1,0)-DATE(YEAR(TODAY()),MONTH(J1),1))/7))-J10-J11-J12

Or, you can shorten that a bit by using cells to hold the date boundaries:

L1:

=DATE(YEAR(TODAY()),MONTH(J1),1)

L2:

=DATE(YEAR(TODAY()),MONTH(J1)+1,0)

Then:

=SUM(INT((WEEKDAY(L1-{1,2,3,4,5},2)+L2-L1)/7))-J10-J11-J12

--
Biff
Microsoft Excel MVP


"mp" wrote in message
...
I have a spreadsheet that I sent to a collegeau who is having difficulty
with
one of the formulas. The formula is returning the #NAME? error in the
cell.
However when she sent the spreadsheet to me the formula works correctly.
Here's the formula:
=NETWORKDAYS(DATE(YEAR(TODAY()),MONTH(J1),1),DATE( YEAR(TODAY()),MONTH(J1)+1,0))-J10-J11-J12

The formula is used to determine the number of available shipping days in
a
month minus planned shutdown days, etc.

Why does the formula work on one computer and not the other???