I want to pull out/extract data through Excel Formula

I have a portfolio of almost 20,000 Customers as mentioned in Excel Sheet. I want to pull out/extract data through Excel Formula for the followings:

1). How to Mark Status of each customer in Excel Sheet as "Matured", "Pre-Matured" or Blank "Outstanding" with the help of Excel Formula.

2). How to Mark Pre-Matured if any Customer want to avail Pre-Maturity option in the excel sheet with the help of Excel Formula.

=IF(G3<=$L$1,"Matured",IF(G3>$L$1," ","Pre-Matured"))

3). How to Pull out data of Customers those have become eligible for 6 month Coupon (in the case of 3 years & 5 Years only) with the help of Excel Formula.

=IF(AND(I3=3-Years,I3=5-Years),EDATE(F3,6)," ")

Kindly Help me.