Return no results if a date value is older than a set date.

I am using the following formula to get the previous month based on cell I3.

=EOMONTH(I3,-2)+1

How can I get it to display nothing when the result is 05/2019 or older for the date?

Thanks for any help with this.

Try it this way:

=IF(EOMONTH(I3,-2)+1 <= DATE(2019,5,31),"",EOMONTH(I3,-2)+1)

I assume you mean anything in May or earlier (i.e. before 1st June 2019) should be blank.

Hope this helps.

Pete

Thanks, yeah that is what I wanted and works, but I have an issue when I drag down, example attached.

thanks, for your help.

Change it to this in A4:

=IF(A3="","",IF(EOMONTH(A3,-2)+1 <= DATE(2019,5,31),"",EOMONTH(A3,-2)+1))

then copy down.

Hope this helps.

Pete

Perfect, thank you so much!