Adjustment to Network days

[xxsalahxx]

Hello

Im trying to use this piece of analysis to work out network days in column N on a spreadsheet.

=IF(J2="","",NETWORKDAYS(J2,M2))
However I would like it to work out if J2 is blank and also if M2 is blank to leave column N blank. I would also like no errors to show
Is there a way?

 

[etaf]

how about

=IF(OR(J2="",M2=""),"",NETWORKDAYS(J2,M2))

 

[xxsalahxx]

how about

=IF(OR(J2="",M2=""),"",NETWORKDAYS(J2,M2))

Thank you for your help, thats working perfectly!!

 

[etaf]

you are welcome
on your profile - it has version 2007 - maybe worth updating if different now