You can’t combine conditions like that. Instead of testing x>=y<=z, you need to use a logical AND and test both x>=y and y<=z.
=IF(AND(TODAY()>=E2, TODAY()<=F2),"Running",IF(AND(TODAY()>=F2, TODAY()<=G2),"Grace","Expired"))
2
solved If formula with 3 different conditions [closed]