Work Distribution over Weeks

hi JD, welcome to the forum. say Start date in A2 & End date in B2, then this will give you the days without Fridays:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))<7))

to obtain the Jobs per day is simply:
=700/SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)))<7))

you could even have a list of holidays, say in F2:F6 & this will calculate the number of holidays within your date range:
=SUMPRODUCT(($F$2:$F$6>=A2)*($F$2:$F$6<=B2))

so if you need to, you can combine the Jobs/(workdays - holidays)

if you have Excel 2010, there is a new function NETWORKDAYS.INTL where you can choose workdays that is Sunday to Thursday.