Hello,
I would like to make one formula for the 4 arguments below (1,2,3 actually work with the formula below)
But argument 4 shows an empty result instead of MC = OOM.
Could you please assist how to modify the formula?
=IF(AND(MONTH(A2)=MONTH(A1),DAY(A2)<DAY(A1)),A2,IF(A1>A2,A1,""))
11/9/2022 OOM (A1)
11/10/2022 Cont (A2)
MC (A3)
Arguments:
1) If OOM is next month or later than Cont; MC = OOM +
2) If OOM is same month but day later than Cont.; MC = Cont +
3) If OOM is earlier then Cont (cont is next month or later); MC = blank +
4) If OOM is earlier then Cont.date (cont is same month); MC = OOM -
Thank you in advance!
Bookmarks