Excel - Data to Date conversion with multiple formats
Asked By adammled
27-Jan-10 12:13 AM
I have a single column of data that includes dates in two formats:
mddyy
mddyy hh:mm
I tried using the Data>Text-to-Columns... with mdy to change them to dates.
It worked for the mddyy data, but it messed up the mddyy hh:mm data.
I need to convert these so I can sort them by year>month>day>hour>minute.
Month
(1)
Mddyy
(1)
Year
(1)
Day
(1)
Mdy
(1)
Jacob Skaria replied to adammled
If all the dates are in excel date format and not in text format...You can
custom format that to display date in any format along with the time for
example m/d/y hh:mm:ss and then the normal sort would sort the dates in
sequence..
--
Jacob
of the data has letter in front and others don't, some have the full year typed out then month then day and others don't. the data is what I call garbage but like is that this vendor must make lots of changes to their website titles as last month they had certain title names and they had them in certain columns and now in possible before and after) The two dates that start with an eight are both in mddyy format. How do you know that the Date Code Answer for those two entries is
Year & Month format Excel Hi, I have col which contains year & month. Now i want to pull the values which is less than or equal to current month. A 2006-08 2008-04 2007-11 2008-01 2007-11 I tried with this formula but it is not working. Can any one help me? = IF(year(a2)&"-"&MONTH(A2)< = year(TODAY()&"-"&month(today()), MONTH(TODAY())&"-"&YEAR(TODAY()), "") - Christ Excel Worksheet Discussions TEXT (1) €žChristopher
Calculate month & year in between two dates Excel I have to calculate gratuity of an employee. for that reasone I have to calculate total month & year from the date of joining to leaving date of employee. example - A B C 1 Date of Joining Date of Leaving Total Month & Year 2 11 / 02 / 2003 28 / 11 / 2006 in C2 I have to use a formula to calculate month & year, if calculate month is greater than 6 month then it round up 1 year else
get a foluma that must look at a date field, determine if it is this month / year, grab a value from a column, if it is a previous month / year, grab a value from a different column, and if it is a future month / year, grab zero. I have some experience with multiple IF statements, but never one that needed to act on a month / year. I have a sample if you want it, just send me your email address. Does