Recurring dates, that end at a specified stop date

[panesai1]

Hi all

I have the following XL sheet.
The formula in Cell C3 is repeated all the way across Row 3, so that it always calculates the date (in Column A) plus the number of months noted in Row 2.
I would like to know how to make the formula generate a blank cell, if there is an end date entered in column B.
The blank cells should only occur after the end date (not before the end date).

In the example shown below, Cells F3, G3, H3..etc should be blank, because they occur after the end date shown in B3.

Any help would be greatly appreciated.

Panesai1


[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]...[/TD]
[TD]Z[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]MONTH[/TD]
[TD]MONTH[/TD]
[TD]MONTH[/TD]
[TD]MONTH[/TD]
[TD]...[/TD]
[TD]MONTH[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD="align: center"]START DATE[/TD]
[TD="align: center"]END DATE [/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]...[/TD]
[TD="align: center"]24[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]07-May-2014[/TD]
[TD]15-Aug-2014[/TD]
[TD]=DATE(Year($A3),MONTH($A3)+C$1,DAY($A3))

RESULT: 07-Jun-2014[/TD]
[TD]07-Jul-2014[/TD]
[TD]08-Aug-2014[/TD]
[TD]08-Sep-2014[/TD]
[TD]...[/TD]
[TD]07-May-2016[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Try

=IF(AND(ISNUMBER($B$3),EDATE($A3,C2)>$B$3),"",EDATE($A3,C2))

 

[panesai1]

Many thanks @gaz_chops.
Sorted!

I adjusted a couple of the $ signs so that I could pull the formula across and down, but apart from that, the formula works great.
Thanks again,

panesai1

 

[gaz_chops]

you're welcome.