Network days - Returns error sometimes.
 

Hi,

I'm using the beow mentioned formula to calculate the NUMBER-OF-WORKING-DAYS
in the month,@5 day work week(Mon-Fri).

=NETWORKDAYS(EOMONTH(D2,-1)+1,EOMONTH(D2,0))
Where 'D2' is '=now()' to calculate current date.

This formula calculates the PRESENT-WORKING-DAY in the month (assuming 5 day
week Monday - Friday and D2 is now() i.e. present day)).
=NETWORKDAYS(DATE(YEAR(D2),MONTH(D2),1),D2)

My Question ?
Both these formulas work on some PCs and not on others ('Name' error shows).
Could this be the excel version or the addins not being on some PCs?

Does anyone have a solution?

Thx,
Matt.

Network days - Returns error sometimes.
 

The Analysis Toolpak Addin must be loaded (tools/Add-ins) for these to work
properly.
Bob Umlas
Excel MVP

"Matts" wrote:

Hi,

I'm using the beow mentioned formula to calculate the NUMBER-OF-WORKING-DAYS
in the month,@5 day work week(Mon-Fri).

=NETWORKDAYS(EOMONTH(D2,-1)+1,EOMONTH(D2,0))
Where 'D2' is '=now()' to calculate current date.

This formula calculates the PRESENT-WORKING-DAY in the month (assuming 5 day
week Monday - Friday and D2 is now() i.e. present day)).
=NETWORKDAYS(DATE(YEAR(D2),MONTH(D2),1),D2)

My Question ?
Both these formulas work on some PCs and not on others ('Name' error shows).
Could this be the excel version or the addins not being on some PCs?

Does anyone have a solution?

Thx,
Matt.