Date format

[shifan]

Hi, i have converted on PDF file to Excel but date format is messed up. im trying to minus one date from another to find the number of days but some of the giving me #value! msg. No matter how many time i tried its the same. how to change it to date format, please help

15/04/13</SPAN>	30/06/13</SPAN>	#VALUE!</SPAN>
15/05/13</SPAN>	30/06/14</SPAN>	#VALUE!</SPAN>
16/05/13</SPAN>	30/06/15</SPAN>	#VALUE!</SPAN>
02/06/13</SPAN>	30/06/16</SPAN>	#VALUE!</SPAN>
03/06/13</SPAN>	30/06/17</SPAN>	#VALUE!</SPAN>
04/06/13</SPAN>	30/06/18</SPAN>	#VALUE!</SPAN>
27/06/13</SPAN>	30/06/19</SPAN>	#VALUE!</SPAN>
28/06/13</SPAN>	30/06/20</SPAN>	#VALUE!</SPAN>
29/06/13</SPAN>	30/06/21</SPAN>	#VALUE!</SPAN>
15/05/13</SPAN>	30/06/22</SPAN>	#VALUE!</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=3></COLGROUP>

thanks in advance

 

[Akashwani]

Hi and welcome to MrExcel.

Take a look here and see if Chandoo has the solution you require....

How to Convert Text to Dates [Data Cleanup] | Chandoo.org - Learn Microsoft Excel Online

I hope that helps.

Ak