Yes, networkdays has stopped before, I know that one time it was because I
had turned off the Automatic Calculation option.

Thanks for suggesting the formula. I'm sure that will work, I'm stumped as
to why it has stopped working.

Steve



"T. Valko" wrote:

Networkdays Stopped Working - Again

Again meaning it's happened before?

How about a replacement formula that doesn't depend on the ATP?

A1 = start date
B1 = end date
C1:C5 = holiday list (if you're using the Holidays argument)

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6),--(ISNA(MATCH(ROW(INDIRECT(A1&":"&B1)),C1:C5,0))))

If you're not using the Holidays argument:

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&B1)),2)<6))


--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Hi there -

The networkdays function stopped working in all my workbooks today. I
**DO** have the Analysis Toolpak installed and I **DO** have the Automatic
Calcuation Option turned on. Any thoughts?

Thanks,
Steve