Hi Max
no need for first getting the Year, month, day
=TEXT(A2,"mm/dd")

for example would be sufficient :-))


--
Regards
Frank Kabel
Frankfurt, Germany


Max wrote:
One way ..

Assuming the dates are in col A, A2 down,

Put:
In B2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"mm/dd")
In C2: =TEXT(DATE(YEAR(A2),MONTH(A2),DAY(A2)),"yy")

Select B2:C2, copy down

Col B will return the month/day,
col C will return the year
--
Rgds
Max
xl 97
I have an EXCEL 97 worksheet that includes a column with birthdays
in the format 11/13/51, for instance, for November 13, 1951. I
would like to split that column into two columns. The first column
would contain the month and day (that is, 11/13) and the second
column would contain the year (that is, 51). How can I do this?