Working Days

I

ianripping

How can I use the Workday function to workout how may working days ther
are in the month entered into cell A1

A1 = 1/1/0
 
F

Frank Kabel

Hi
I'd use NETWORKDAYS in combination with EOMONTH (Assumption: Analysis
Toolpak installed):
=NETWORKDAYS(A1,EOMONTH(A1,0))

HTH
Frank
 
J

Jazzer

Hi,

This array formula should do the trick

=SUM((WEEKDAY(A1+ROW(INDIRECT("1:"&(DATE(YEAR(A1),MONTH(A1)+1,1))-A1))-1,2)<6)*1)

because it's an array formula it should be entered by pressing
ctrl+shift+enter instead of plain enter.

- Asser
 
Top