G
gareth
I want to put a formula in cell I2
I want it to do the following:
a. Check that C2 has a date in it, if not enter “” in I2
b. Check that date in H2 is more than two months after the
date in cell C2, if yes then enter “Yes” in I2
c. Check that date in E2 is less than a month more than
date in I2, if yes then enter “Yes” in I2
d. If not b. or c. then enter “No” in I2
I have tried a couple of formula but cannot get them to
work.
Thanks in advance.
Gareth
I want it to do the following:
a. Check that C2 has a date in it, if not enter “” in I2
b. Check that date in H2 is more than two months after the
date in cell C2, if yes then enter “Yes” in I2
c. Check that date in E2 is less than a month more than
date in I2, if yes then enter “Yes” in I2
d. If not b. or c. then enter “No” in I2
I have tried a couple of formula but cannot get them to
work.
Thanks in advance.
Gareth