Hello excel friends,
I hope you had a nice week so far.
I am stuck with a formula and I just don't get why it's not working. I've been trying a lot, but I am not able to figure it out. Therefore I hope you guys could hep me out, I believe it's pretty easy for you.
So it's actually just part of the formula that doesn't work, that is why I simplified it a lot.
I have a contract with a start date and it's financial impact is always 2 months after the actual start.
For that reason I tried to use a MONTHS & YEARS formula in order to solve it. The conditions are the following.
IF the actual month is before the start that then leave it empty (or in this case return TRUE)
IF the actual month is 2 or more months after the start that then return FALSE
I create the formula =IF(MONTH($B5)+2&YEAR($B5)>MONTH(L$3)&YEAR(L$3),"TRUE","FALSE")
For some reason the formula works, but for some reason starting from October it doesn't work anymore, and I simply do not understand why. If I take a look into the formula it would be IF(62019>102019), which should be FALSE, but for some reason it returns TRUE. Why is that?
I attached you a excel with 1 line that includes the formula and another line that shows how it supposed to be. Please have a look and let me know if that's enough of information.
I hope you guys can help me out! Thanks sooo much in advance!
Best,
AFGP
Bookmarks