Solved

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

Posted on 2011-03-11
2
381 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 500 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

Expert Comment

by:Ingeborg Hawighorst
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn various types of data validation for different data types in Excel 2013.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now