I have a Spreadsheet which contains Weekly Dates from Cell E2 thru AJ2.

If I place an "X" in any of the Cells below these Cells I would like to copy
the date to Column D corrisponding to the Row which has the "X" in it.

i.e. If Cell G5 has an "X" in it I would like to copy the date in G3
(11/7/2008) to Cell D5 (7-Nov-2008)

Is there a standard formular or function to do this? If not could you lead
me down the right path?