Day Function Format VBA

vbanewbie68

New Member
Joined
Oct 16, 2021
Messages
45
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Attachments

  • Day function VBA issue.png
    Day function VBA issue.png
    149.7 KB · Views: 9

vbanewbie68

New Member
Joined
Oct 16, 2021
Messages
45
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,159
Office Version
  1. 365
Platform
  1. Windows
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).
 

Forum statistics

Threads
1,148,396
Messages
5,746,447
Members
424,020
Latest member
LongDoo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top