difference between dates

A

Ankur

Hi,

When i m calculating the difference between date in the US format downloaded
from the system it is showing error #VALUE!, however if i manually change the
date in the column then it calculate the difference.

HOwever as there are lot of datas in excel it will take lot of time. Any
idea how to do it quickly?

Regards,
Ankur
 
E

excelent

try
=SUBSTITUTE(A1;" ";"")
or
=SUBSTITUTE(A1;"'";"")
or
=SUBSTITUTE(A1;"""";"")
or
=A1*1


"Ankur" skrev:
 
G

Gord Dibben

Ankur

Data>Text to Columns>Next>Next>Column Data Format>Date>choose a format>OK

OR..............copy an empty cell.

Select the column and Paste Special>Add>OK>Esc

You will have to re-format the column to Date.


Gord Dibben MS Excel MVP
 
Top