Find expiry date and informing if cheque near to expiry

[forginganewone]

[FONT=&quot]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")))[/FONT]
[FONT=&quot]I just want to get this part to work fine : IF((EDATE($I3,5))<TODAY()-30,"Near expiry","Pending")[/FONT]
[FONT=&quot]The cheque date is in I column.[/FONT]
[FONT=&quot]Required : The cheques expire after 6months from their date. So i want it to start showing near expiry status if their last 30 days have started but show expired if today() is > edate(I3,6).
But if both of these above criteria are false and CountA($L3)=0 then show "pending"[/FONT]

 

[Special-K99]

You dont need COUNTA

=IF($L3<>0,"Delivered",IF(EDATE($I3,6)<=TODAY(),"Expired",IF(EDATE($I3,5)>=TODAY(),"Pending")))

 

[forginganewone]

There is also the 4th option of near expiry which was the main trouble.
When it is more than 5months and less than 6months form cheque date it should show "Near to expiry"
after 6 months it should show "Expired"
Time between cheque date and 5months "Pending"

 

[Special-K99]

Try

=IF($L3<>0,"Delivered",IF(EDATE($I3,6)<=TODAY(),"Expired",IF(EDATE($I3,5)<=TODAY(),"Near to expiry","Pending")))