I want to take a date 2006/02/10 & break it into separate columns

B

Bernard Liengme

Assuming the values are real dates formatted as yyyy/mm/dd:
use =YEAR(A1) = MONTH(A1) and =DAY(A1)

But if the entries are text:
=--LEFT(A1,2) , =--MID(A1,6,2), =--RIGHT(A1,2)
The double negation (that's the two signs after =) will convert text to
numbers.

best wishes
 
C

Curtis

Thank you very much!

cd

Bernard Liengme said:
Assuming the values are real dates formatted as yyyy/mm/dd:
use =YEAR(A1) = MONTH(A1) and =DAY(A1)

But if the entries are text:
=--LEFT(A1,2) , =--MID(A1,6,2), =--RIGHT(A1,2)
The double negation (that's the two signs after =) will convert text to
numbers.

best wishes
Click to expand...
 
R

Ron Rosenfeld

If it is a true Excel Date, then, with the date in A1:

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

or something similar.

You could also use custom formatting if all you wanted to do was display the
date portions, as opposed to actually having the numerical year, month, day in
the different columns.
--ron
 
Top