Date (dd-mm-yy) > need to split into 3 columns (ie dd mm yy)

G

Guest

Hi there
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate columns ... (ie. column A = dd , column B = mm and column C = yy)
Does anyone know how I can segment the date into 3 different columns
Thanks very much for anyone's help....
Ti
 
A

Alan

Tim Elhatton said:
Hi there,
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate
Click to expand...
columns ... (ie. column A = dd , column B = mm and column C = yy).
 
A

Alan

With the date in A1
In B1 =TEXT(A1,"dd")
In C1 =TEXT(A1,"mm")
In D1 =TEXT(A1,"yy")
Tim Elhatton said:
Hi there,
I have a column of dates (dd-mm-yy) that I want to split into 3 seperate
Click to expand...
columns ... (ie. column A = dd , column B = mm and column C = yy).
 

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

date conversion from mm/dd/yy to dd/mm/yy 3
change DD/MM/YY to MM/DD/YY 6
How to enter a date in DD-MM-YYYY format 2
Create a date column (MM/DD/YY) that fill sout automatically? 3
date computing and sum issues 6
Need mm-dd-yy for date but helpless 2
convert dd and mm and yy fields to one dd/mm/yy field 4
Split DATE cell into three new cells? 2

Top