ONE STANDARD DATE FORMAT (Form different date formats one standard date format)

[filiplenox]

[TABLE="width: 711"]
<TBODY>[TR]
[TD]10.2013</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]01.10.2013 </SPAN>[/TD]
[TD]201310</SPAN>[/TD]
[TD]001</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Oct 13</SPAN>[/TD]
[/TR]
[TR]
[TD]11.2013</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]01.11.2013</SPAN>[/TD]
[TD]201311</SPAN>[/TD]
[TD]002</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nov 13</SPAN>[/TD]
[/TR]
[TR]
[TD]12.2013</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]01.12.2013</SPAN>[/TD]
[TD]201312</SPAN>[/TD]
[TD]003</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Dez 13</SPAN>[/TD]
[/TR]
[TR]
[TD]01.2014</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]01.01.2014</SPAN>[/TD]
[TD]201401</SPAN>[/TD]
[TD]004</SPAN>[/TD]
[TD][/TD]
[TD="colspan: 4"][/TD]
[TD]</SPAN>Jan 14</SPAN>[/TD]
[/TR]
[TR]
[TD]02.2014</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]01.02.2014</SPAN>[/TD]
[TD]201402</SPAN>[/TD]
[TD]005</SPAN>[/TD]
[TD]============>>>[/TD]
[TD]Feb 14</SPAN>[/TD]
[/TR]
[TR]
[TD]03.2014</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]01.03.2014</SPAN>[/TD]
[TD]201403</SPAN>[/TD]
[TD]006</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Mar 14[/TD]
[/TR]
[TR]
[TD]04.2014</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD]01.04.2014</SPAN>[/TD]
[TD]201404</SPAN>[/TD]
[TD]007</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Apr 14[/TD]
[/TR]
[TR]
[TD]05.2014</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]01.05.2014</SPAN>[/TD]
[TD]201405</SPAN>[/TD]
[TD]008</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Mai 14[/TD]
[/TR]
[TR]
[TD]06.2014</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]01.06.2014</SPAN>[/TD]
[TD]201406</SPAN>[/TD]
[TD]009</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jun 14[/TD]
[/TR]
[TR]
[TD]07.2014[/TD]
[TD]10</SPAN>[/TD]
[TD]01.07.2014</SPAN>[/TD]
[TD]201407</SPAN>[/TD]
[TD]010</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]</SPAN>Jul 14[/TD]
[/TR]
[TR]
[TD]08.2014</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]01.08.2014</SPAN>[/TD]
[TD]201408</SPAN>[/TD]
[TD]011</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]</SPAN>Aug 14[/TD]
[/TR]
[TR]
[TD]09.2014</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]01.09.2014</SPAN>[/TD]
[TD]201409</SPAN>[/TD]
[TD]012</SPAN>[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sept 14[/TD]
[/TR]
[TR]
[TD]

I would appreciate it to get help how to convert different date formats in one standard date format [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]



[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL span=8></COLGROUP>[/TABLE]

 

[Slizer6893]

I would use the TEXT formula

=Text("Date","MMMM/YYYY") Output: January/2000
=Text("Date","MMM/DD/YY") Output: Jan/15/2000

etc

 

[filiplenox]

Thank you for your reply.
It is clear now for the dates but how could I do it for the accounting periods too. In my case, 001 or 1 represents October, 002 or 2 represent November and so on...

 

[Slizer6893]

Might have to use a helper sheet for this

Say you have 001 or 1 in A1 and in B1 you want the date, October

On Sheet 2 you would have A1:A12 with the Months, and B1:b12 the Number representing them

Pulling from another sheet =index(Sheet2!A1:A12,match(A1,Sheet2!B1:B12,0))

Not sure otherwise unless you write a really long nested IF formula which can be done easily just ugly and annoying to fix if it gets messed up somehow.