put a cell value into a cell when the range of cell contain a specfic text

Hi All,


How do i put a cell value into a cell when the range of cell contain a specfic text.
For example, in the sample below, i want to put the cell value (13/2/2014) into B3 when a range of cell contain (A) Sam.

Excel.jpg

Is it possible as well that i can copy the cell value (13/2/2014) to all fields in column B till it reaches TOM (A1) for example?

Please enlighten me.
Thanks