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

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.
apr8Asked:
Who is Participating?
 
wdosanjosConnect With a Mentor Commented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
@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
All Courses

From novice to tech pro — start learning today.