Excel - Date Analysis

CarlCarlos

New Member
Joined
Jan 12, 2011
Messages
31
All,

I have an issue with some raw data I have. The system I am using dumps out a long list of dates which I need to analyse, however the dates it spits out are inconsistent in format i.e. some are in date format, some are in text format.

Is there any formula to convert the list to a similar format and then another to analyse the date by month?

An example of the raw data is below. Thank you in advance, any help would be so greatly appreciated

10/02/2012
10/02/2012
7/26/2012
7/26/2012
8/28/2012
8/28/2012
8/28/2012
8/28/2012
8/28/2012
09/07/2012
8/28/2012
9/25/2012
9/25/2012
9/25/2012
10/26/2012
10/26/2012
10/26/2012
10/26/2012
10/26/2012
9/25/2012
6/22/2012
9/14/2012
5/28/2012
06/06/2012
07/04/2012
7/17/2012
09/11/2012
09/11/2012
9/18/2012
9/21/2012
10/19/2012
10/23/2012
11/06/2012
08/07/2012
9/14/2012
9/21/2012
10/19/2012
10/24/2012
10/26/2012
10/09/2012
09/07/2012
10/16/2012
10/26/2012
10/26/2012
10/26/2012
6/22/2012
09/04/2012
09/04/2012
6/22/2012

<colgroup><col></colgroup><tbody>
</tbody>
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
Select a column of dates, Data > Text to Columns, click Next twice, tick Date and select MDY then click Finish.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,211
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top