Hi Dav-
Your original formula this morning worked great. On this one, you referenced
A1. That is the company name column that the earlier formula addressed. The
issue is that the B column (date that the 3,5 and 30 is added to) sometimes
is blank. If so, the formula returns 1/5/1900. If theres no date in the B
column, I was hoping for the formula to leave the results column blank.
Thats the column thats showing the B1+3,5 and 30 results from your formula.
Is there a way to add this final criteria to your original formula? Thanks
again.

"Outbacker" wrote:

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.