| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofilter by month & year when I have a column full of dates ?? | Excel Discussion (Misc queries) | |||
| Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
| Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
| count no. of dates in a column that falls on certain month & year | Excel Worksheet Functions | |||
| sort dates by day then month, not by year. | Excel Worksheet Functions | |||
Linear Mode
