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,
Hannah
=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 🙂
