Date formula Help

[DawnaP]

Good morning, I need to set up a formula. I have a spreadsheet that calculates future dates for review. What I need my formula to do is to calculate a future date only if the cell is greater than a specific number IF not then blank. in the example below I only want future dates to populate if the options years meet the criteria, so for a one year option I only want option 1 to be filled in but not option 2 or three. Conversely if there are three option years I want all three to fill in. Can I do this with a great than/less than formula or what if, not sure how to proceed.
to get my expiry date here is the formula which i started with. =DATE(YEAR(H11)+O11,MONTH(H11),DAY(H11))

thanks for your feedback

example I have a contract that has 2 option years. I need
[TABLE="width: 500"]
<tbody>[TR]
[TD]contract date [/TD]
[TD]expiry [/TD]
[TD]years option[/TD]
[TD]option 1[/TD]
[TD]option 2[/TD]
[TD]option 3[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/Jan/2016[/TD]
[TD]1/Jan/2017[/TD]
[TD]2[/TD]
[TD]1/Jan/2018 [/TD]
[TD]1/Jan/2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/Feb/2016[/TD]
[TD]2/Feb/2017[/TD]
[TD]1[/TD]
[TD]2/Feb/2018[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]28/Jan/2016[/TD]
[TD]28/Jan/2017[/TD]
[TD]3[/TD]
[TD]28/Jan/2018[/TD]
[TD]28/Jan/209[/TD]
[TD]28/Jan/2020[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 755"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD="align: right"] [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Tetra201]

Is this what you need?

=IF(COLUMNS($A$1:A$1)>$O11,"",EDATE($H11,12*COLUMNS($A$1:A$1)))

 

[DawnaP]

I will give this a try, Thank you

 

[DawnaP]

Sorry, this did not work. I can manually remove the years I don't want. I was hoping to have a formula where I did not have to remove them.

 

[Tetra201]

Assuming you have the expiry dates in range H11:H13 and years option in range O11:O13, place the formula in cell P11 and drag-copy across and down as needed.