NETWORKDAYS WORK AROUND

[rcteel81]

Currently trying to find a work around for NETWORKDAYS. I'm aware of the Analysis ToolPak Add-In, but would like a work around so users of my job aid will not need to add it.

I found a formula that can calculate the number of specified days in a time period, so I'm using it to determine Saturdays and Sundays and then subtracting it from the total days in the time frame. However, it seems to not be 100% accurate when testing it. Here is the formula:

=SUM(IF(WEEKDAY(A2 + 1 + ROW(INDIRECT("1:"&TRUNC(B2-A2) +1)))=C2,1,0))

where A2 = Start Date
B2 = End Date
C2 = Day of week number ( 1-Sunday, 2-Monday, ...7-Saturday)

Does anyone know why this wouldn't be working or a better way to go about finding the business days for a time period without using networkdays? Thanks.


Ryan

 

[Richard Schollar]

Hi Ryan

Here's one possibility:

Excel Workbook
	A	B	C	D
2	01 February 2007	25 February 2007	17	17
Sheet3

 

[rcteel81]

Thanks Richard. This was exactly what I needed.

 

[barry houdini]

This formula will also give the same result as

=NETWORKDAYS(A2,B2)

=SUM(INT((WEEKDAY(A2-{2,3,4,5,6})+B2-A2)/7))