S
Susan Hayes
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
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