Hi

I have to measure two criteria referral to assessment , assessment to delivery

I have used referencing in order to do this thanks to the advice on this forum.

Referral to Assessment
Formula: copy to clipboard 
=NETWORKDAYS('[WHEELCHAIRS MONTHLY REPORT JULY 15.xlt]boo824qy'!$C11,'[WHEELCHAIRS MONTHLY REPORT JULY 15.xlt]boo824qy'!$D11,'C:\Documents and Settings\ben.healy\Desktop\SERVICE REPORT\[HOLIDAY.xls]Sheet1'!$D$2:$D$10)


eg. REFERRAL 22/07/15 ASSESSMENT 22/07/15

**this returns a figure of 1


Assessment to Delivery
Formula: copy to clipboard 
=NETWORKDAYS('[WHEELCHAIRS MONTHLY REPORT JULY 15.xlt]boo824qy'!$D11,'[WHEELCHAIRS MONTHLY REPORT JULY 15.xlt]boo824qy'!$I11,'C:\Documents and Settings\ben.healy\Desktop\SERVICE REPORT\[HOLIDAY.xls]Sheet1'!$D$2:$D$10)


eg. ASSESSMENT 22/07.15 DELIVERY (BLANK)

**this returns a figure of -30143 due to the blank in delivery date,the ones with a delivery date seem to work but as some items haven't been delivered I think I'd like it to return a '0'


Both these formulas also use a holiday range. However I have a couple of issues with the results returned.

If there is no date in Delivery on the original sheet it assumes the date is 00/01/1900 which when calculated in the above formulas returns a value of -30143

I really hope I've explained this properly.

Thanks

Ben