I ianripping Jan 28, 2004 #1 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
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 Jan 28, 2004 #2 Hi I'd use NETWORKDAYS in combination with EOMONTH (Assumption: Analysis Toolpak installed): =NETWORKDAYS(A1,EOMONTH(A1,0)) HTH Frank
Hi I'd use NETWORKDAYS in combination with EOMONTH (Assumption: Analysis Toolpak installed): =NETWORKDAYS(A1,EOMONTH(A1,0)) HTH Frank
J Jazzer Jan 28, 2004 #3 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
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
