I need to have a date cell (D2) automatically filled in with the date on which that row was completed. If the data capturer filles in the client details in another cell (F2), I would like to have the date permanently input into cell D2.
Please assist
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>Thanks
Please assist
NUM | CONFIRMATION AGENT INITIALS | PLEDGE AGENT INITIALS | INITIAL DATE DATE YYMMDD | LANGUAGE | PHONE (CELL) |
1 | LR | 150401 | English | 0833836255 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col span="3"></colgroup><tbody>
</tbody>