Splitting dates

[Mike]

Hi

Anybody have an answer to a problem I don't see any solution ? I have a
spreadsheet with 25,000+ lines. Within the line one column is a date of
birth in the format 04/04/1954.............is there any way to "split"
this date into three seperate columns (Day) (Month)
(Year)............what we want to be able to do is address those on the
list on the month of their birth. Grateful for any help

MNW

 

[Sandy Mann]

Try

=DAY(A10)

=MONTH(A10)

=YEAR(A10)

HTH

Sandy

 

[Gord Dibben]

Mike

Assuming column A contains dates.

In B1 =YEAR(A1) skip this if only month needed.

In C1 =MONTH(A1)

In D1 =Day(A1) skip this if only month needed.

Select B11 and double-click on the fill handle of D1.

You can then sort by month.


Gord Dibben Excel MVP

 

[Mike]

Mike

Assuming column A contains dates.

In B1 =YEAR(A1) skip this if only month needed.

In C1 =MONTH(A1)

In D1 =Day(A1) skip this if only month needed.

Select B11 and double-click on the fill handle of D1.

You can then sort by month.


Gord Dibben Excel MVP

Many thanks.........seems too simple..........