Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help on Networkdays
I'm trying to find the number of business (working) days between two dates.
I am using the Networkdays function however it returns the number of whole workdays between two dates. Eg. 1.00 or 2.00 or 3.00 I need fractional days in order to denote a certain time of day. Eg. Start date: Friday, September 2, 2005 End date: Wednesday, September 7, 2005 Holidays: Labour Day: September 5, 2005 The answer received is 3.00 However I need to set a time as of 3:00 pm on September 7 for example. Start date: Friday, September 2 1 Tuesday, September 6 1 Current date Wednesday, Septmeber 7 15/24 Total 2..625 Thank you Susan |
#2
|
|||
|
|||
Hi Susan,
Assuming your start date in A1 your End Date in B1 Holidays is your range of holidays! : =IF(A1B1,0,NETWORKDAYS(A1,B1,Holidays) -IF(NETWORKDAYS(A1,A1,Holidays),MOD(A1,1)) -IF(NETWORKDAYS(B1,B1,Holidays),1-MOD(B1,1))) Format as Number with decimals : Regards, Daniel M. "Susan Hayes" wrote in message ... I'm trying to find the number of business (working) days between two dates. I am using the Networkdays function however it returns the number of whole workdays between two dates. Eg. 1.00 or 2.00 or 3.00 I need fractional days in order to denote a certain time of day. Eg. Start date: Friday, September 2, 2005 End date: Wednesday, September 7, 2005 Holidays: Labour Day: September 5, 2005 The answer received is 3.00 However I need to set a time as of 3:00 pm on September 7 for example. Start date: Friday, September 2 1 Tuesday, September 6 1 Current date Wednesday, Septmeber 7 15/24 Total 2..625 Thank you Susan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS() not avaialbe after reopening | Excel Worksheet Functions | |||
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed | Excel Worksheet Functions | |||
NETWORKDAYS function problem | Excel Worksheet Functions | |||
Networkdays shows as #NAME even though I have the toolpack instal. | Excel Discussion (Misc queries) | |||
MS Excel Function - Networkdays | Excel Worksheet Functions |