Networkdays Stopped Working - Again
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
|