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

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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Curtis" wrote in message
...

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

Thank you very much!

cd

"Bernard Liengme" wrote:

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Curtis" wrote in message
...

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

On Wed, 20 Sep 2006 08:37:03 -0700, Curtis
wrote:


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