networkdays formula

[kizzieb85]

I am using a simple netwrokdays formula with a -1 on the end. This formula works fine but to make my spreadsheet more jazzy I want the formula to provide a blank if neither/or one of the date fields is blank, trouble is now I keep getting the Value# error, I think this is to do with the - 1, any ideas how i can get rid of it. My forumla is

=IF(A4="","",AND(IF(F4="","",NETWORKDAYS(A4,F4,Holidays!$A$1:$A$6)-1)))

A4 is start date and F4 is end date

Thanks

 

[VoG]

Try

=IF(OR(A4="",F4=""),"",NETWORKDAYS(A4,F4,Holidays!$A$1:$A$6)-1)

 

[kizzieb85]

perfect thank you!