I creating a basic checklist in an Excel spread sheet and need advice on how
to fill a static date into the adjacent cell. e.g. when I type any caracter
into A2, I need the current date so fill in automatically into AB. The date
must not reset each time I open the work sheet. So far, I got this formula.
=IF(D7="?", NOW(), "")
However, I don't know what the ? mar should be in order to fill the date
into the adjacent cell by entering any character.
Will appreciate your support.
Thanks, FS.