Hi rdawbrey

Give this a try

=IF(OR(L2="",L2="void"),"",IF(OR(TODAY()>=EDATE(I2,6),TODAY()>=EDATE(L2,6)),1,""))

In future it would be helpful if you can include an attachment with sample data and their expected result.

Sunny

Hi Sunny,

Please see the attached file

Try this then in cell R2

=IF(K2<>"","",IF(OR(TODAY()>=EDATE(H2,6),TODAY()>=EDATE(K2,6)),1,""))

Sunny

Hi Sunny,

The above formula does the trick. I am having a hard time putting this in a sentence so I understand how the formula works. The part that is confusing me is bold, underlined and italic.  

=IF(K7<>"","",IF(OR(TODAY()>=EDATE(H7,6),TODAY()>=EDATE(K7,6)),1,""))

 In my mind I read it something like this

If K7 is not blank then leave cell blank, but if the date H7 is greater than or equal to 6 months or……then put a 1 otherwise leave blank

Thanks,

Diane

Hi Sunny,

If column H does not have a date I also need the cell with the formula to be blank.

Thanks

Hi Diane

Maybe I misunderstood your request as I thought you wanted a 1 if the effective date is > 6 months. I too was wondering earlier why you wanted this.

One of the issues I am having is if the date in L is >than 6 months it wants to put a 1 in the cell with the formula.

If that is the case, then give this a try in cell R2:

=IF(OR(H2="",K2<>""),"",IF(TODAY()>=EDATE(H2,6),1,""))

Explanation:

If Issue Date (H2) is a blank or Effective Date (K2) is not a blank, then show a 1 else show a blank.

Otherwise

If Issue Date (H2) is more than 6 months (compared to today's date) then show a 1 else show a blank.

Hope I got it right this time.

Sunny

Sunny,

This is perfect and the explanation makes it clearer for me.

Thanks,

Diane