Collumn A has a selection of dates
i.e
1/3/2005
2/3/2005
7/3/2005
9/3/2005

Note: They are not consecutive (otherwise this would be too easy!)

On a sheet 2, I want to be able to type a date in a cell. Then have a
function by which all the cells beneath are populated by the corresponding
dates on the first sheet.

In other words excel needs to lookup a date in a specified collumn with the
result then coming from the row beneath where the original number is.

I hope this makes sense! Please help!