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
...

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
...

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