Separating dates from one column to Month, Date, Year columns
 

I'm looking for a way to take a list of dates that are being cut and pasted
from an Access Database into excel and separate it so I can sort by Month,
Day, Year. The data seems to be recognized in Excel as a date because it
sorts by the the year. The format is mm/dd/yyyy. When I try to change the
format to anything else, it won't allow the change.

Separating dates from one column to Month, Date, Year columns
 

with something like:
08/06/2008
in A1

In cells B1 thru E1 enter:
=DATEVALUE(A1)
=YEAR(B1)
=MONTH(B1)
=DAY(B1)


--
Gary''s Student - gsnu200798


"frogstyle" wrote:

I'm looking for a way to take a list of dates that are being cut and pasted
from an Access Database into excel and separate it so I can sort by Month,
Day, Year. The data seems to be recognized in Excel as a date because it
sorts by the the year. The format is mm/dd/yyyy. When I try to change the
format to anything else, it won't allow the change.

Separating dates from one column to Month, Date, Year columns
 

If it's really a date, you could use a helper column with a formula like:

=text(a1,"mmddyyyy")
drag down as far as you need it

And then sort by this helper column.



frogstyle wrote:

I'm looking for a way to take a list of dates that are being cut and pasted
from an Access Database into excel and separate it so I can sort by Month,
Day, Year. The data seems to be recognized in Excel as a date because it
sorts by the the year. The format is mm/dd/yyyy. When I try to change the
format to anything else, it won't allow the change.

--

Dave Peterson