View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matts Matts is offline
external usenet poster
 
Posts: 29
Default 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.