MINIFS in Google Sheets based on another cell

I have a tracking sheet on Google Sheets with a start date in one column and a complete date in another for multiple companies. I need to return the oldest "Open" date for each company and then the overall oldest "Open" date. I also need it to return the word "Current" if no data.

Example in excel file attached.
FORMULA FOR WOB.xlsx

I did get a formula that works in my excel file but will not work in Google Sheets. Any suggestions?

Example used in excel: =INDEX(SORT(FILTER($E$12:$E$39,($D$12:$D$39=$A4)*($E$12:$E$39<>"")*($E$12:$E$39<>0)*(($F$12:$F$39="")+($F$12:$F$39=0)),"Current")),1)

How about

Formula:

Please Login or Register  to view this content.

Thank you all. Fluff13, your formula works great!

Glad to help & thanks for the feedback.