#NAME? Error

[mp]

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???

 

[JudithJubilee]

Hi mp,

She will need to install the Analysis Toolpack.

Go to Tools + Addins + Check Analysis Toolpak.

Judith

 

[Pete_UK]

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

 

[T. Valko]

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