Need to combine dates stored in seperate columns

  • Thread starter Thread starter mrcosna
  • Start date Start date
M

mrcosna

I have data that has the month and day together in one column ex. 125
and in the other is the year 2007

How do I get the date to be 12/5/2007?
 
well it is stored as text and the months that are not two digit have a zero
in front
 
Ok. Assume A1 has 125, and B1 has 2007
=DATE(B1,LEFT(A1,2),RIGHT(A1,LEN(A1)-2))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two dates 5
Convert text date to mmddyyy date 2
Expanding Date formula 1
Sum Column by Date Range 3
Sort Dates 11
How do i convert a date into 3 seperate columns? 2
Count date 5
Convert dates stored as text 2

Back
Top