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

[Guest]

 

[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

 

[Guest]

Thank you very much!

cd

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

 

[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