Forum Discussion
Solved
If/Or functions
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, Ha...
=IF((A1>=EDATE(B1,-6))*(A1<=EDATE(B1,6)),"yes","")
Perhaps this formula returns the intended result.
=IF((A1>=EDATE(B1,-6))*(A1<=EDATE(B1,6)),"yes","")
Perhaps this formula returns the intended result.
Thanks, just what I needed 🙂