I need a formula that will calculate the following: Consider the date value of four independent columns + 450 days (15 months) and use the most recent date as due date.
Example:
Column 1-12/31/99+450=x
Column 2-12/31/99+450=x
Column 3-12/31/99+450=x
Column 4-12/31/00+450=x
Result: Consider x of all four columns and use column 4 because it is the most recent date.
Have tried to develop if statement and was unsuccessful.
