How do I convert a birthdate format from yyyy/mm/dd to mm/dd/yyyy

A

Amy Ann

I tried going to format cells, then date, then the mm/dd/yyyy format. All I
get a #######. I tried expanding the cells but that didn't work either.
 
P

Pete_UK

It might be that your data is in text format, so reformatting the
cells won't work. Assuming your birthdate is in A1, try this in B1:

=DATE(LEFT(A1,4),MID(A1,6,2),RIGHT(A1,2))

Format this cell as mm/dd/yyyy.

Hope this helps.

Pete
 
D

daddylonglegs

If dates are text formatted you can convert to true dates this way.

Select column > Data > Text to columns > Next > Next > under "Column data
format" select "Date" and specify YMD > Finish
 

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 dd/mm/yy to mm/dd/yyyy 3
how do I change the date format from yyyymmdd to mm/dd/yyyy 4
Excel is seeing the date as dd/mm/yyyy 4
Converting mm/dd/yyyy to yyyy/mm/dd 6
Forcing a date entry format of dd/mm/yyyy 1
SAVE AS CSV, KEEP DATE FORMAT 2
convert date mm/dd/yyyy to dd/mm/yyyy 2
How to enter a date in DD-MM-YYYY format 2

Top