Formula for mm/dd/yyyy extract into separate columns?

  • Thread starter Thread starter Guest
  • Start date Start date
Sneilan, use the Text to Columns command on the Data menu. Delimited text,
with / as the separator. Afterwards, format all cells as General.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Sneilan,

If A1 = mm/dd/yyyy, then use the following formulas in
other cells

B1 = MONTH(A1)
C1 = DAY(A1)
D1 = YEAR(A1)

Mike
 
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

Sumproduct Question 4
reformat dates to yyyy/mm/dd 5
Formatting Dates from Text to Numbers 2
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
date 1
Sumproduct and weekday from mm/dd/yyyy format? 3
Excel 2002: How to make the date format uniform ? 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2

Back
Top