Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate business days between 2 dates | Excel Discussion (Misc queries) | |||
How can I calculate the number of business days between two dates | New Users to Excel | |||
Business Days Only | Excel Discussion (Misc queries) | |||
Is there a way to calculate business working days between dates i. | Excel Worksheet Functions | |||
How do I find how many business days are between two dates | Excel Worksheet Functions |