Creating MM/DD/YY from 3 separate columns

[Craig]

I am wanting to create one column (Column D) formatted
with the DATE function, with the data coming from three
separate columns, where Column A has Month, Column B has
Day, and Column C has Year. Does anyone have a solution
for this?

thank you.

Craig

 

[Aladin Akyurek]

In D2 enter:

=DATE(C2,A2,B2)

and format the formula cell as desired.

 

[craig]

What about when Column A has text (i.e., the 'month' is
spelled out as a year?). Thanks for your help.

Craig

 

[Aladin Akyurek]

Would you post the entries that you have in A2, B2, and C2 as they are?

 

[Guest]

Hi! Thanks for your help.
I would like to convert the text January to "1", February
to "2", but I would not mind having the date read 31
October, 2004 either. (Either way).

thanks,
Craig

 

[Frank Kabel]

Hi
do you mean the month value is for example
January

If yes try
=DATEVALUE(B2 & "-" & A2 & "-" & C2)

 

[Aladin Akyurek]

A2: January
B2: 24
C2: 2004

D2:

=DATE(C1,MONTH(A1&"-1"),B1)

You can custom date format as desired.