Expiry date Formula & AutoFilter VBA

Dear All,

In the attached file, can someone help me with the following:

1-why the formulas shaded in pink are not working?

2-why the formulas shaded in yellow are working, while the ones shaded in green are not working. Also, if I put these parentheses {}, like in the yellow shaded formulas, the pink formulas turns into a text.

3-Can you pls write a small VBA for me that auto filters to me any cell I want in the database in the attached file? This VBA should do the same thing as the AutoFilter function in Ecxel.

Many thanks for your help and support and I look forward to receiving your reply

Nasser
Dubai