Formula to Calculate # of Workdays

M

Mike

Can someone help with a formula to calculate the number of workdays for each
Monday to Friday week that are included in a specified Start Date and End
Date?

I've provided a sample below.

Thanks,

Mike Rischard

A B C D E
F G H I
1| Monday 8/23/2004 8/30/2004 9/6/2004 9/13/2004 9/20/2004
2|StartDate End Date Networkdays Friday 8/27/2004 9/3/2004 9/10/2004
9/17/2004 9/24/2004
3|8/31/2004 9/9/2004 8 0 4 4 0 0
4| 9/2/2004 9/16/2004 11 0 2 5 4 0
 
M

Mike

I used Networkdays to calculate the days from Start Date to End Date.

I need a formula to show the number of work days for each week, within a
Start Date and End Date range. Example: (need formula to calculate the
0,2,5,4,0 workdays for each week in the period 9/2/2004 to 9/16/2004.

Monday
8/23/2004 8/30/2004 9/6/2004 9/13/2004 9/20/2004
Start Date End Date Net Workdays Friday 8/27/2004 9/3/2004
9/10/2004 9/17/2004 9/24/2004
9/2/2004 9/16/2004 11 0
2 5 4 0
 
M

Mike

Networkdays from 09/02/04 (Start Date) to 09/16/04 (End Date) = 11.

Workweeks covering the period 9/02/04 to 09/16/04 are:
Mon Fri Need Formula to Calc Workdays
8/30/04 to 9/03/04 2 (09/02/04 to 09/03/04) 09/02/04 is Start
Date above
9/06/04 to 9/10/04 5 (09/06/04 to 09/10/04) this entire week
is in the period above
9/13/04 to 9/17/04 4 (09/13/04 to 09/16/04) 09/16/04 is End
Date above

Thanks,

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top