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

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

If this post helps click Yes
---------------
Jacob Skaria

"Jacob Skaria" wrote:

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
---------------
Jacob Skaria

"dgold82" wrote:

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.

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