Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Merge mm, dd, yyyy from different columns into date format: Mar-01-2011

Posted on 2011-03-11
2
Medium Priority
?
423 Views
Last Modified: 2012-06-27
I have mm in one column, dd in a second column and yyyy in third column in excel.  I want a new column to show Mar-01-2011 format.  Please help.
0
Comment
Question by:apr8
2 Comments
 
LVL 23

Accepted Solution

by:
wdosanjos earned 2000 total points
ID: 35112800
Use the following formula, then apply a custom format to the Date column (mmm-dd-yyyy).

mm     dd     yyyy     Date
03     11     2011     =DATE(C2,B2,A2)

Open in new window


I hope this helps.
0
 
LVL 50
ID: 35113208
@wdosanjos: the Date() syntax is Date(year, month, day), so, using your example, it should be

=date(C2,A2,B2)

Not for points.

cheers, teylyn
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This collection of functions covers all the normal rounding methods of just about any numeric value.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn various types of data validation for different data types in Excel 2013.
Viewers will learn how to find and create templates in Excel 2013.

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question