If Function

Occasional Visitor


I am trying to use the if function as follows: =If(A5<EDATE(TODAY(),2),"Good",IF(A5>EDATE(TODAY(),3),"Close","Check"))


and it "works" but it doesn't follow the rule when I change the date, what am I doing wrong?

Thank you

1 Reply

@cestrada20 Well, the rule that the formula follows is the if the date in A5 is less than 2 months from today (1st reference date) it returns "Good". If the date is after 3 months from today (2nd reference date) then you'll get "Close". Any date between the 2 reference dates will return "Check".


If that is not the logic you seek, you need to re-write the formula.