This is the formula i am trying to get to work : =IF(COUNTA($L3)=1,"Delivered",IF(EDATE($I3,6)<=TODAY(),"Expired",IF((EDATE($I3,5))<TODAY()-30,"Near expiry","Pending")))
I just want to get this part to work fine : IF((EDATE($I3,5))<TODAY()-30,"Near expiry","Pending")
The cheque date is in I...