How do I construct a date in Excel VBA from a shortened month name ?

Ask Question Forum:

Model Library:2025-02-08 Updated:A.I. model is online for auto reply question page

Show

ASK RECENT

How do I construct a date in Excel VBA from a shortened month name ?

Asked by Tocogroup

at 2024-07-25 04:18:24

Point:500 Replies:4 POST_ID:829101USER_ID:11762

Topic:

Microsoft Excel Spreadsheet Software;;

Hi Experts,

I have an Excel sheet in which dates are split out across 3 columns. For example, I have 01 in column A, "Sep" in column B and 2013 in column C.

I want to create a formatted date (dd/mm/yyyy) in column D. How do I do this in VBA (I can do it manually entering a formula) ?

Thanks
Toco

Expert: duncanb7 replied at 2024-07-25 04:44:02

Thanks for your points

Have a nice day

Duncan

Author: Tocogroup replied at 2024-07-25 04:42:43

Many thanks. That works fine.

To answer the previous expert's question I used =DATEVALUE(1&"/"&MONTH(C2&1)&"/"&B2) as a formula within the sheet. No doubt this can be adapted to a VBA solution.

Accepted Solution

Expert: duncanb7 replied at 2024-07-25 04:27:25

500 points EXCELLENT

You can try this
Duncan

Sub test()Sheets(1).SelectWith ActiveSheet.Range("D1").NumberFormat = "dd/mm/yyyy".Range("D1").Value = .Range("A1") &. Range("B1") & .Range("C1")End WithEnd Sub

1:2:3:4:5:6:7:

Select All Code

Expert: Randy Poole replied at 2024-07-25 04:25:30

which formula are you using?

新聞財經娛樂♬資訊 News Economy

About Us|Service|Pricing

Stock Index全球即時指數期貨:

&nbps;

News即時新聞:↓

News即時新聞:↑

On Balance Volume (OBV):

Youtube Video♬ Sharing by members:↓

Youtube Video♬ Sharing by members:↑

Ask Question Forum:

How do I construct a date in Excel VBA from a shortened month name ?

Your Information

Members/Profolio