HI,
creating such a macro would be quite tricky, and on the top of that, you might be needed to adjust the macro yourself if your cells are moved or extended in any way. It is also a solution which might be a little unsure, since any type of mistake/error/systemproblems etc, might cause the date to change to todays date by "accident".

I am not sure what you want to achieve by your new question. I find it even easier to press "CTRL+Y" in a cell to get the complete job done (including the date), instead of typing "Yes" followed by an enter (and in addition have a really complex macro to maintain/write).

I suggest that you stay with the short and easy macro

Kind regards
Bjorn