So I'm trying to help my brother setting up his company and I need some help with an excel.

He has an excel sheet with some clients, phones and an expiration date on some certificates so my idea is to make a function (Or whatever i need) for the Excel to make another table sepparately, warning him that said certificates are about to expire and show him the same date (Client name, phone, and expiration date).

I know some basic functions and I cannot find the solution, I need to make a function that counts how many certificates are about to expire (3 days before due date approx.), after that I thought about an HLOOKUP function with the system date and a 3 days, but I think that would throw the same results over and over again, so I need your help.

Edit: So I've thought this a bit now, and I think the best way to do it is and HLOOKUP function that returns the value when its true and skips the row when false, any ideas on how to do it?

Thanks a lot