the formula is

=IF(OR(A1="company1",A1="company2"),B1+3,IF(OR(A1="company3",A1="company4"),B1+5,B1+30))

the B column of my spreadsheet contains dates. the problem is, if there is

no date in the B column, this formula returns 1/5/1900. what could i add at

the end of this formula so that it leaves the cell blank if there is no date

in column B. thanks in advance.

## Bookmarks