=IF(E3>=0,(DAY(B2)>1)+MONTH(B2)&"/1")+0

=IF(OR(E3>=0),DATE(YEAR(B1),MONTH(B2),DAY(B1)))

Here is what i'm trying to attempt....

if E3 is 0 (zero) or greater i would like B6 to be polulated with the Month and year from B2 and the day from B1.
If E3 is less than 0 (zero) I would like the the date to be rounded to the beginning of the next month after the date in B2 (in this case 10/1/12)

Thanks in advance!Help.xlsx