Splitting dates

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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 B1:D1 and double-click on the fill handle of D1.

You can then sort by month.


Gord Dibben Excel MVP
 
Gord said:
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 B1:D1 and double-click on the fill handle of D1.

You can then sort by month.


Gord Dibben Excel MVP
Click to expand...

Many thanks.........seems too simple..........
 
Back
Top