Day Function Format VBA

[vbanewbie68]

Hi Sir or Madam
I am new to VBA in excel. I need your help please to see how to use the Day function VBA to focus on ‘Day’ only, rather than in the month and year format. Your help is much appreciated.

Please see some screenshots below – first one is my code for a test, and then the 2nd screenshot is the spreadsheet - Take a look at the Gift Day of the Month Column where I need to have just Day only, rather than the full format of date. I hope everything makes sense.

Best regards
vbanewbie68

 

[vbanewbie68]

If it is a new question, it is best to ask it in a new thread.
That way if I do not know the answer or am not available at the time to answer it, others will see it as a new unanswered question in the "Unanswered threads" list, and your chances of receiving assitance increase greatly.

Yes it is a new question so I will add it in a new thread.
Regards

 

[Joe4]

I changed the "Solution" post you had marked. Typically, you want to mark the actual post that contains the solution (not the one that acknowledges that the problem has been solved).