formula help to get date from four cell through criteria, if not found result blank

dear excel expert

i am looking for help from you i have dates in 4 four cells i want formula to get dates from any one of cells. Through Cell Values From (Acutal Pod,Lenovo Pok,Parnter Pok,Commited Eta)

First Check In Acutla Pod If Date Not Found In Actual Pod, Then
Lenovo Pok If Date Not Found In Lenovo Pok Then
Partner Pok If Date Not Found Then
At Last Committed Eta. Even Though If Date Not Found In Four Cell Result "Date Not Found".

Find the attachment you may get understand....

any one help on this thread?

Any experts put your efforts on this?

AMERICANPIE_dane.xlsx

IF(D2="",IF(B2="",IF(C2="",IF(E2="","No Date Found",E2),C2),B2),D2)

With reference to your attached sheet, This should do the work

simply copy the formula , paste on any cell in your sheet and drag it down.

I had added the formula in the sheet attached (see columns in blue)

suberb dan-e works perfectly..Thanks Thread been solved by you only