Good day,
I would like to know if any formula would work for the following.
A B C D
6 YES 20DEC 20JAN

1.If a,b,c,d are all like above then E should be D + 2 months.
2.If A are 0, then D are 0.
3.I B are No, then E should be C + 6 months.

Thanks