Lookup formula required?

[NeroM]

Okay, I'd be grateful if someone could help me with a formula to solve the problem below:

I have a table with in one tab where I want to put a date in cell A1, in the cells to the right on that row (B1, C1, D1, etc) I want a formula that will search the date that I've inserted in cell A1, then look for this date in an array of dates elsewhere that are organised as a column (lets say the array of dates starts in cell A11 (continues in A12, A13, A1 etc) and then insert the consecutive dates on from the first date.

A simple vlookup would normally suffice here, but the date that I insert in A1 could be anywhere in the lookup table.

(please ignore the attachment)

Thanks in advance.