Andy:

My analysis toolpak is loaded.... What next?

Sandi

"Andy" wrote:

> Hi
>
> I think NETWORKDAYS is part of the Analysis toolpak, so make sure that is
> loaded in Tools/Add-ins.
>
> Andy.
>
> "RUSH2CROCHET" <RUSH2CROCHET@discussions.microsoft.com> wrote in message
> news:FE0485F5-5EB9-484A-AA84-ACC5D55888E6@microsoft.com...
> > Hello everyone:
> >
> > I have a worksheet of order transactions which my group processes. I
> > would
> > like to determine for FTR's the
> > # of work days elapsed between Fax Date & Approval Date.
> >
> > Column A represents the type of transaction (FTR, Purchase, Rental,etc.)
> > Column Q is Fax Date
> > Column U is Approval Date
> >
> > I have placed the following in Column AC:
> >
> > =IF(A:A="FTR",DAYS360(Q:Q,U:U))
> >
> > This works fine, yet when I put NetworkDays in place of Days360, it
> > returns
> > #NUM!
> >
> > Can someone please give me guidance? All help appreciated!
> >
> > TIA,
> > Sandi
>
>
>