Hi,
one suggestion to avoid a macro would be that you after entering the yes, steps two cells to the right (= to column D).

In this cell press CTRL and semicolon, which will enter todays date as a fix value in that cell.

Kind regards
Bjorn