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