Choose Latest Date and Number of Month Criteria for Future Date

[ShakJames]

Hi all

I have been racking my brain on how to do this, or at least fit it into one formula. In the Table below, I want in column D to calculate a future date based on criteria and picking the latest date out of column A & B. The future date needs to be in either 24 or 15 months based on whether Column C shows 24 or 15. See below.

Capture.GIF

So basically Column D (in the above example) would use Date 2 because it's the latest date and would calculate what the date would be in 24 months. However, if Date 1 was a later date for example 02/02/2017, it would ignore Date 2 and use Date 1 and if column C said 15 months it would calculate at 15 months instead of 24.

I hope this makes sense. Any help would be greatly appreciated.

Thanks all!

[JohnTopley]

try

=IF(A1>B1,DATE(YEAR(A1),MONTH(A1)+C1,DAY(A1)),DATE(YEAR(B1),MONTH(B1)+C1,DAY(B1)))

[sweep]

Hi,

Does this work for you?

=DATE(YEAR(MAX(A1:B1)),MONTH(MAX(A1:B1))+C1,DAY(MAX(A1:B1)))

[ShakJames]

Hi both...

John, thank you for all your help again! That's worked brilliantly. It really is appreciated.

Sweep - I have not tried yet, but I will do. Thanks for your post as well.