Remove non-business days between dates

[dgold82]

My supervisor asked me to calculate how long it takes to perform certain
projects. In one column I have start date and the other is the end date.

I would like to calculate the number of days in between but take out the
non-business days (i.e. Saturday, Sunday).

Is this possible? Thanks.

 

[Jacob Skaria]

Or use
=networkdays(A1,B1,)

Function available with in Analysis ToolPak Add-In. To install from menu
Tools>AddIns>Check 'Analysis ToolPak'

If this post helps click Yes

 

[dgold82]

Thanks!

With Start Date in A1 and End Date in B1 try the below formula in C1 which
will give you the number of days from to both inclusive (except weekends)

=(B1-WEEKDAY(B1,2)+WEEKDAY(A1,2)-A1)/7*5-MIN(5,WEEKDAY(A1,2))+MIN(5,WEEKDAY(B1,2))+1

If this post helps click Yes

 

[James Silverton]

Jacob wrote on Mon, 29 Jun 2009 07:14:01 -0700:

Function available with in Analysis ToolPak Add-In. To install
from menu

Tools>> AddIns>Check 'Analysis ToolPak'

If this post helps click Yes

"Jacob Skaria" wrote:

I might point out that some people (like me) do not include some public
holidays as workdays and NETWORKDAYS can take a list of holidays.

--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not