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

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

Back
Top