Or use
=networkdays(A1,B1,)

Function available with in Analysis ToolPak Add-In. To install from menu
ToolsAddInsCheck '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.