If/Or functions

[HannahKing]

Hi.

I am trying to write a formulae which will return me "yes" if a date in column a is between 6 months before  or after another date in column b. Any thoughts on how to do this?

Thanks,

Hannah

[#2 · Accepted solution]

@HannahKing 

=IF((A1>=EDATE(B1,-6))*(A1<=EDATE(B1,6)),"yes","")

Perhaps this formula returns the intended result.

[#3]

Thanks, just what I needed 🙂