Creating MM/DD/YY from 3 separate columns

  • Thread starter Thread starter Craig
  • Start date Start date
C

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
 
What about when Column A has text (i.e., the 'month' is
spelled out as a year?). Thanks for your help.

Craig
 
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
 
Hi
do you mean the month value is for example
January

If yes try
=DATEVALUE(B2 & "-" & A2 & "-" & C2)
 
A2: January
B2: 24
C2: 2004

D2:

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

You can custom date format as desired.
 
Back
Top