Excel - Date Analysis

[CarlCarlos]

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

[TABLE="width: 97"]
<colgroup><col></colgroup><tbody>[TR]
[TD]10/02/2012[/TD]
[/TR]
[TR]
[TD]10/02/2012[/TD]
[/TR]
[TR]
[TD]7/26/2012[/TD]
[/TR]
[TR]
[TD]7/26/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]09/07/2012[/TD]
[/TR]
[TR]
[TD]8/28/2012[/TD]
[/TR]
[TR]
[TD]9/25/2012[/TD]
[/TR]
[TR]
[TD]9/25/2012[/TD]
[/TR]
[TR]
[TD]9/25/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]9/25/2012[/TD]
[/TR]
[TR]
[TD]6/22/2012[/TD]
[/TR]
[TR]
[TD]9/14/2012[/TD]
[/TR]
[TR]
[TD]5/28/2012[/TD]
[/TR]
[TR]
[TD]06/06/2012[/TD]
[/TR]
[TR]
[TD]07/04/2012[/TD]
[/TR]
[TR]
[TD]7/17/2012[/TD]
[/TR]
[TR]
[TD]09/11/2012[/TD]
[/TR]
[TR]
[TD]09/11/2012[/TD]
[/TR]
[TR]
[TD]9/18/2012[/TD]
[/TR]
[TR]
[TD]9/21/2012[/TD]
[/TR]
[TR]
[TD]10/19/2012[/TD]
[/TR]
[TR]
[TD]10/23/2012[/TD]
[/TR]
[TR]
[TD]11/06/2012[/TD]
[/TR]
[TR]
[TD]08/07/2012[/TD]
[/TR]
[TR]
[TD]9/14/2012[/TD]
[/TR]
[TR]
[TD]9/21/2012[/TD]
[/TR]
[TR]
[TD]10/19/2012[/TD]
[/TR]
[TR]
[TD]10/24/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/09/2012[/TD]
[/TR]
[TR]
[TD]09/07/2012[/TD]
[/TR]
[TR]
[TD]10/16/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]10/26/2012[/TD]
[/TR]
[TR]
[TD]6/22/2012[/TD]
[/TR]
[TR]
[TD]09/04/2012[/TD]
[/TR]
[TR]
[TD]09/04/2012[/TD]
[/TR]
[TR]
[TD]6/22/2012[/TD]
[/TR]
</tbody>[/TABLE]

 

[VoG]

Select a column of dates, Data > Text to Columns, click Next twice, tick Date and select MDY then click Finish.