i have a spreadsheet that has a starting date, completion date, and the 3rd
column is elapsed # of days using formula =NETWORKDAYS(A2,B2) in column 3.
Problem is if I don't have any date entered in completion date yet i get a
negative # in column 3 example -28491 or -28473 where this should be zero
until i enter the completion date.

thx 2 all

char