Excel function to convert month-day-year to mm/dd/yyyy

  • Thread starter Thread starter sweetthing4luc
  • Start date Start date
S

sweetthing4luc

I have an excel formula question. I need to do the following and I am unsure
how to do it. I have three columns that represent a birthday, in column one
I have the month spelled out, in column two I have the date of birth and in
the third column I have the year. In the forth column that I will create, I
need to have the date of birth together as such mm/dd/yyyy. Unfortunately
there are thousands of entries this way and I want to find one simple
function that can convert these entries into one item. If you have the
solution please let me know. Thank you so much.
 
Hi,

assuming the following
A1 January
B1 28
C1 2008

Try

=DATEVALUE(B1&A1&C1)

If you put this in d1 and double click the fill handle it will fill down as
far as there are data in column C

Mike
 
if u have month in A1, Days in B1 and Year in C1
one way to do it would be.
=A1&" "&B1", "&C1
but this will give you this format.
January 20, 2008
 
Thanks. If you liked that one, then you will probably like this more compact
version which I just came up with...

=--(B1&A1&C1)
 

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

Converting mm/dd/yyyy to yyyy/mm/dd 6
Excel is seeing the date as dd/mm/yyyy 4
converting dd/mm/yy to mm/dd/yyyy 3
Convert a text field to a date 6
How to convert the dates from the YY:DD forma to MM/dd/YYYY format 4
convert date mm/dd/yyyy to dd/mm/yyyy 2
How to Convert 24/03/2010 as text into 03/24/2010 date format 2
change birthday display from mm/dd/yyyy to HIDE the yyyy? 1

Back
Top