NETWORKDAYS

[lascough]

With help from Mr Excel members I have been able to create a spreadsheet which can calculate the number of days passed between two dates. The following formula works (where A9 is the start date and J9 the end). I have used the -1 at the end to knock off the date of ordering.

=IF(OR(A9="",J9=""),"",NETWORKDAYS(A9,J9))-1

The thing is, when no dates are enetered the cell displays #VALUE.

I have tried using ISERR and ISBLANK to correct this but I must be doing something wrong as I can not get it to work.

Any ideas???

 

[fairwinds]

Hi,

Just move the last paranthesis:

=IF(OR(A9="",J9=""),"",NETWORKDAYS(A9,J9)-1)

 

[lascough]

That easy eh. What a waste of the last hour.

Thanks very much.