Solved

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

Posted on 2011-03-11
2
374 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:teylyn
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Video by: Zack
Viewers will learn about using Excel in a browser with Excel Online.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

746 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

12 Experts available now in Live!

Get 1:1 Help Now