NETWORKDAYS woes

[norjms]

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.
[TABLE="width: 500"]
<TBODY>[TR]
[TD]DayofTraining
[/TD]
[TD]WHAT DAY
[/TD]
[TD]WHAT DOING
[/TD]
[TD]HOURS USED
[/TD]
[/TR]
[TR]
[TD]-4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]-1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]TEACHING OBJ A
[/TD]
[TD]6
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]2
[/TD]
[TD]TEACHING OBJ B
[/TD]
[TD]8
[/TD]
[/TR]
</TBODY>[/TABLE]

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.
[TABLE="width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]CLASS#
[/TD]
[TD]STARTDATE
[/TD]
[TD]GRADDATE
[/TD]
[TD]DayofTraining
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]26-Mar-2013
[/TD]
[TD]5-Jun-2013
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]2
[/TD]
[TD]3-Apr-2013
[/TD]
[TD]13-Jun-2013
[/TD]
[TD]-3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]WEEKSTART
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]1-Apr-2013
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CLASS#
[/TD]
[TD]Monday 1 Apr
[/TD]
[TD]Tuesday Apr 2
[/TD]
[TD]Wed Apr 3
[/TD]
[TD]Thursday Apr 4
[/TD]
[TD]Friday Apr 5
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Day 5
[/TD]
[TD]Day 6
[/TD]
[TD]Day 7
[/TD]
[TD]Day 8
[/TD]
[TD]Day 9
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Day 1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]