Days since excluding weekends and holidays

Closed
Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
Hello,

I am trying display the number of days since a given date, excluding holidays and weekends. The NETWORKDAYS function includes the start date, which I do not want added to the number of days. i.e. Start date is:12/16/09, Completion date:12/23/09, result is: 5 (workdays since start date).

1 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
Check this link out, it explains networkdays function.
http://www.ehow.com/how_2238499_use-excels-networkdays-function.html
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month