I'd love some assistance conbining these two formulas in to one!

[gentelmanjack]

=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

[TheExcelphile]

Enter the following formula in B6:

=IF(E3>=0,DATE(Year(B2),MONTH(B2),DAY(B1)),DATE(YEAR(B2+32),MONTH(B2+1),DAY(1)))

Don't forget to click the little star to the left of this post if you feel I helped!

[gentelmanjack]

=IF(E3>=0,DATE(YEAR(B2),MONTH(B2),DAY(B1)),DATE(YEAR(B2+32),MONTH(B2)+1,DAY(1)))

I tweaked it a little.

Thanks very much!!!

Star fo you!

[TheExcelphile]

Thanks for the star!

It was stupid of me to misplace the brackets... well done sorting that out