Adding current date in next empty cell

Hello,

could you help me with this please?

Is it possible to use macro-code that adds current date in wanted cell, and day after in the cell next to it.

Like this;

I run the macro, it adds todays date in cell AN23, tomorrow I run the code again, it adds tomorrows date in cell AO23, day after AP23 etc etc.

Thanks in advance!

Is there any data in the cells before AN23, i.e. does AL23 contain an entry?

Try this

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

This code is slightly better

Please Login or Register  to view this content.