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