# NETWORKDAYS woes

#### norjms

##### New Member
I'm having a aweful time getting a class tracking sheet to work. We normaly have around 30 classes running at a time and need to track what day of training each class is on for each day on a weekly calendar. Previously we were figuring it manualy but, I'm trying to save sometime. The original spreadsheet is more in depth using several more fields but this is a basic example.

I used something like this to lookup the values to populate the weekly calendar. The table for the class # start date grad date and ay of training is named crslist

There is another table called OBJECTIVE
THat shows on the calendar so we can see what each teaching is doing on each day, how many hours are needed, and one for the day of training.
 DayofTraining WHAT DAY WHAT DOING HOURS USED -4 -3 -2 -1 1 1 TEACHING OBJ A 6 2 2 TEACHING OBJ B 8

<TBODY>
</TBODY>

I populate the calendar by doinging something like

Monday
=IF(A1="","",VLOOKUP(VLOOKUP(A1,CRSLIST,4),OBJECTIVE,2))

Friday
=IF(A1="","",VLOOKUP(VLOOKUP(A1,CRSLIST,4)+4,OBJECTIVE,2))

Figuring the number of days of training since class start
Class 1 =NETWORKDAYS(B2,A7) ->5
Class 2 =NETWORKDAYS(B3,A7) -> -3

I run into issues when classes start mid week like below. If Monday is Apr 1st then a class starting on Apr 3rd would start on Wednesday not, like excel shows me on Friday. I have rolling start dates and several hundred classes to track. Any help on how to fix this would be great.
 A B C D 1 CLASS# STARTDATE GRADDATE DayofTraining 2 1 26-Mar-2013 5-Jun-2013 5 3 2 3-Apr-2013 13-Jun-2013 -3 4 5 6 WEEKSTART 7 1-Apr-2013 CLASS# Monday 1 Apr Tuesday Apr 2 Wed Apr 3 Thursday Apr 4 Friday Apr 5 1 Day 5 Day 6 Day 7 Day 8 Day 9 2 Day 1

<TBODY>
</TBODY>

### Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Replies
7
Views
205
Replies
3
Views
184
Replies
7
Views
434
Replies
2
Views
290
Replies
2
Views
116

1,207,392
Messages
6,078,223
Members
446,323
Latest member
fishezuk

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back