<div>
which formula are you using?
</div>


<div>
Many thanks. That works fine. <br />
<br />
To answer the previous expert's question I used =DATEVALUE(1&amp;&quot;/&quot;&amp;MONTH(C2&amp;<wbr />1)&amp;&quot;/&quot;&amp;B2)<wbr /> as a formula within the sheet. No doubt this can be adapted to a VBA solution.
</div>


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.

<div>
Thanks for your points<br />
<br />
Have a nice day<br />
<br />
Duncan
</div>


Thanks for your points

Have a nice day

Duncan

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have an Excel sheet in which dates are split out across 3 columns. For example, I have 01 in column A, &quot;Sep&quot; in column B and 2013 in column C. <br />
<br />
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) ?<br />
<br />
Thanks<br />
Toco
</div>
</div>


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

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

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.