NETWORKDAYS (for annual leave tracker)

Hi there,

Pretty new to Excel but nonetheless I'm developing a basic Annual leave tracker for an individual member of staff. I've got everything to work by inputting a 'From Date', 'To Date' and by using the NETWORKDAYS function I can show the number of working days has been taken. Also I've set the number of entitled days leave which when subtracted by the total number of days taken so far gives me the remainder of days left that a person can take.

A problem arises when trying to input the formular that don't yet have dates. If the dates cells are left blank the NETWORKDAYS cell displays a '1' which has an effect on the entire tracker. What I believe I need, is some kind of 'IF' function that knows to ignore the NETWORKDAYS operation and input a '0'

Please feel free to open the file and have a look for yourself

Would really appreciate a bit of guidance.


Toby Dyson