Dates with conditions

Hi All

I hope someone can help with this.

I have 2 sheets - one with orders and the second with customer accounts. I want to populate the customer accounts sheet with the dates of the orders automatically using a formula or function. Is this possible?

I have attached an example.

Any help would be great.