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 |
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 |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com