Hi again,
I was in such a hurry before that I didn't check the macro properly

Try this instead (as you see I just quickly edited my previous instruction):

Put cursor in cell B6. Start recording a macro (tools / macro / record...). By clicking on a symbol on the little "macro recorder box" (the one with the stop sign) you shift to "relativ references" (which will be needed here).

Type "yes" (without enter), followed by "arrow right" two times. Now you should by in cell D6.

Now enter the formula =today() in the cell D6. Then (still in D6) run the command "Copy" and after this Edit / Paste special / Values. After this press escape (to hide the area marked for copying).

Stop the recording. Your macro is now ready!

A suggestion is that you assign the macro with a shortcut (for example CTRL + Y).

Now you can just place the cursor in column B (B8 for example) and press CTRL+Y and the job is done!

I really hope it works this time

Kind regards
Bjorn