I am trying to create a formula in excel to count number of working days between two dates and then to minus certain dates if they fall within that range (so that I can hopefully use the formula in sharepoint as have been told excel formulas work in sharepoint.

I can do this if I use the following formula with a column of the dates I2:12
=NETWORKDAYS(A13,B13,I2:I12)

but sharepoint doesnt like this as it cant refer to the column, anyone know how I can type all the separate dates in the formula itself, I have been able to get one date in so it minus the network days by 1 but cant figure how to put all the other other dates in.
=NETWORKDAYS(A13,B13-27/12/2011)

Thanks

Smiffy