Hi everyone,

I hope you can help as I'm really stuck on this calculation below.

In order for the NETWORKDAYS to be worked out, I need data in both Y2 and 02 fields.

Just to summarise:
Y2 = CRB Date (if it has one, else should say "No CRB Date")
02 = Resolution Date (if it has one, else should say "Open" - as it hasn't yet been resolved)

If has has both then it should do the NETWORKDAYS calculation.

Below is what I have but Excel doesn't like it, does anyone know what I've done wrong?

IF(Y2="","No CRB date"),(O2="","Open"),NETWORKDAYS(Y2,O2)-1)))

Thanks so much in advance, this is driving me mad (obviously a total noob)