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 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!