newworkdays

[aiki456]

I've recently opened a workbook that I hadn't looked at in a long tim
and am getting an error in a formula that I'm sure worked at one time.

In cell F6, I input a date which should be in the future.

In two other cells I have the following formulas:

1) =(Networkdays(Today(),F6)-1)

2) =F6-(Today())

For the first formula, the result is #NAME? and running an audit trac
indicates it doesn't like F6. However, the second formula, which als
uses F6, is ok. Does Networkdays not allow a cell reference? As
mentioned, I am certain that this worked at one time.

Thank you for any assistance you can provide

 

[Dave R.]

Networkdays is part of the analysis tookpak. Make sure that under tools>add
ins> analysis tookpak is checked.

 

[JE McGimpsey]

You need to load the Analysis Toolpak Add-in (Tools/Add-ins...)

 

[aiki456]

Wow, you guys are good! That did the trick! Thank you very much,

Aik