Need help developing a formula

[FarleyP]

I need help developing a formula in which column A calendar date (09/01/06) is compared to column B calendar date (09/03/06) and the earlier of the 2 dates plus 30 days goes into column C.

The 3 choices for C are:
If A < B, C = A+30
If A = B, C = B+30
If A > B, C = B+30

Example:
If Column A = 09/01/06 and Column B = 09/03/06, Column C should be 09/01/06 + 30 days = 10/03/06

What I've come up with so far (that doesn't work) is:
=((A+30)IF(A<B))OR((B+30)IF(A>=B))

Thanks for your help.
FarleyP

[Special-K]

Given your three formulas C is either A+30 or B+30, so isnt this simply

=IF(A<B,A+30,B+30)