Forum Discussion
Mel4342
Apr 30, 2021Copper Contributor
Excel formula question.
I have quite a few excel formula questions considering I am new to it. But here's my first one. I have the formula =IF(J4+91>AF4,1,0) I am expecting to get a 1 if the date in j4 +91 is > than the dat...
Riny_van_Eekelen
Apr 30, 2021Platinum Contributor
Mel4342 Your formula should work as desired. Can you giv an example of when it "does not work".
Mel4342
Apr 30, 2021Copper Contributor
For example, it works when j is 12/1/2016. But when j is 8/1/2019 and f is 11/12/2019 it does not. But there are other examples too