Network days - Returns error sometimes.

M

Matts

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.
 
B

Bob Umlas, Excel MVP

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top