<div>
The 2nd one is just the trick! Thank you!
</div>


The 2nd one is just the trick! Thank you!

<div>
If you want the resultant date to be usable, and assuming the year is in YYYY format, the month in MM format and day in DD format, use this...<br />
<br />
=DATE(B2,C2,D2)<br />
<br />
...and then format as date in MM/DD/YY format.<br />
<br />
If the Year is only in YY format, you'll need to do this assuming no years prior to 2000....<br />
<br />
=DATE(2000+B2,C2,D2)
</div>


If you want the resultant date to be usable, and assuming the year is in YYYY format, the month in MM format and day in DD format, use this...

=DATE(B2,C2,D2)

...and then format as date in MM/DD/YY format.

If the Year is only in YY format, you'll need to do this assuming no years prior to 2000....

=DATE(2000+B2,C2,D2)

<div>
<div class="content wysiwyg-content">
Greetings, I have 3 columns (b, c, d) with Year, Month, Day. I would like to merge the values of the 1st 3 cells/columns into the 4th column<br />
eg. in this order for line 2 in column E: &quot;C2/D2/B2&quot;<br />
<br />
Thanks!<br />
JohnD
</div>
</div>


Greetings, I have 3 columns (b, c, d) with Year, Month, Day. I would like to merge the values of the 1st 3 cells/columns into the 4th column
eg. in this order for line 2 in column E: "C2/D2/B2"

Thanks!
JohnD

Excel - merge column values

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

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