Issue using NetworkDays

[karmaimages]

Good Afternoon,

I'm trying to complete a dashboard to see how many items I have which are over SLA so I've used Networkdays

=NETWORKDAYS(A3,Holidays!$G$3,Holidays!$D$3:$D$18)

for example to calculate the number of working days whilst excluding holidays.

The only issue I'm facing is where cells in column A have no date they're coming back with "31582" which is messing with my counts - Is there a way to exclude empty cells from the formula - The number of cells in column will change daily but I didn't want the user to change too many things simply paste an extract of dates.

Many Thanks

 

[eduzs]

=IF(OR(A3="",A3=0),"",NETWORKDAYS(A3,Holidays!$G$3,Holidays!$D$3:$D$18))

 

[karmaimages]

=IF(OR(A3="",A3=0),"",NETWORKDAYS(A3,Holidays!$G$3,Holidays!$D$3:$D$18))

That's perfect, thank you very much

 

[eduzs]

You're welcome.