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