calculating # of days

[Charlene Lee]

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
(e-mail address removed)

 

[Victor Delta]

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
(e-mail address removed)

Changing the formula to =IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)) should sort
it. You could also swap the 0 for "" if you want C2 to be blank?

V