Remove non-business days between dates
 

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.

Remove non-business days between dates
 

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.

Remove non-business days between dates
 

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.

Remove non-business days between dates
 

Thanks!

"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.

Remove non-business days between dates
 

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