excel formula to help my calculation from min dates of 3 dates cell ranges

dear excel expert

i have set of 3 dates A,B,C To calculate no of days from E column


"If 1St Date Greater Than Actend Then Calculate Move To 2Nd Date
If 2Nd Date Is Greater Than Actend Then Calcualte Move To 3Rd Date
If 3Rd Greater Than Actend....Then Result All Date Greater Value"


find the attachment!!! help on this

As a start, you can use this formula

Please Login or Register  to view this content.

It gets more complicated when you have blanks. You have to start putting in a test to see if the cell is blank. You would have to put this into each cell and if it's blank, put in the other tests as the false condition. (A little more work that I want to get into)

Please Login or Register  to view this content.

Thanks Hectop Your formula works perfectly!!! Thanks for being time spent to my post!!!

You're welcome.
Shameless plug - if you haven't please add to my reputation by clicking on the link below my post.