I have dates when something was requested in column 'o' and when it was
received in column 'q'. I had a formula for calculating the number of
days between the two dates and it was working fine. The IT department
just upgraded my Microsoft Office to 2003 and now the formula no longer
works. Any thoughts?

Here's the formula:
=IF(ISBLANK(O9),"",IF(ISBLANK(Q9),"",IF(ISBLANK(Q9 ),"",NETWORKDAYS(O9,Q9)-1)))

By the way, I also tried the formula stripped down to:
=NETWORKDAYS(O9,Q9) and that returned the same error message (which was
#NAME? )

Thanks,
Marilyn

=Networkdays() is part of the analysis toolpak addin.

Tools|Addins
and turn it on.

(Depending on how excel was installed, you may need the CD.)

bakercenter wrote:

I have dates when something was requested in column 'o' and when it was
received in column 'q'. I had a formula for calculating the number of
days between the two dates and it was working fine. The IT department
just upgraded my Microsoft Office to 2003 and now the formula no longer
works. Any thoughts?

Here's the formula:
=IF(ISBLANK(O9),"",IF(ISBLANK(Q9),"",IF(ISBLANK(Q9 ),"",NETWORKDAYS(O9,Q9)-1)))

By the way, I also tried the formula stripped down to:
=NETWORKDAYS(O9,Q9) and that returned the same error message (which was
#NAME? )

Thanks,
Marilyn

--

Dave Peterson

Thank you sooooo much! It was all I needed. :)
Marilyn