If you want to use the NETWORKDAYS function, you must install the
Analysis Tool Pack add-in.

Hope this helps.

Pete

On Oct 3, 9:53 pm, RocketMan
wrote:
For the past two years I have been running metrics on a share drive with the
same simple formula to add up the number of days between two dates and take
out weekends =networkdays(2a,2b) and it works. Recently I got a replacement
laptop and a docking station. Now when I run my macros the column that
provides the answer gives me the "name?" error. So I plug the old desktop
back in and it works fine, plug the laptop in and error. It's the same files.
So I'm thinking maybe this thing doesn't have enough memory or there is
something I have to set up in excel in order for it to read this formula. Any
body got and ideas for this frustrated analyst?