Hi Myrna!

But that won't work if the user includes a list of
holidays and one or the other dates is a holiday.

Yes, I know. That's why I asked the OP if they wanted to
include holidays when I replied. But the OP hasn't
responded and it would be easy to include checks for
holidays.

See this about the #NAME? issue:

http://tinyurl.com/5x3cj

Biff

-----Original Message-----
On Wed, 23 Mar 2005 20:44:15 -0800, "Biff"
wrote:

I came up with this more robust version but I only call
Networkdays once:

But that won't work if the user includes a list of
holidays and one or the
other dates is a holiday. (I know, I'm paranoid about
user errors!)

multiple calls to
Networkdays results in #NAME? if you are troubleshooting
and using Evaluate Formula.

Sounds like a bug in the Evaluate Format routine. I
evaluate parts of a
formula by highlighting in the formula bar and pressing
F9. I don't get any
errors.

.