add the date and day of the month

[chris85]

hello friends,

I have a workbook and a code for date and day of the month, it worked until now, i had to change the table. i tried to fix it but i did not know. i attached a dummy.
could anyone to help me,
any help is really appreciated.

chris

[davesexcel]

What is supposed to happen?

[chris85]

hi dave,
thanks for your question, the date must be in row11 and the day, below, in row 12.

chris

[Bob Phillips]

You can just drag-copy C11:D11 across.

You can simply get the day letter, but what month and year is it for?