difference between dates

G

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting Dates 2
Formula for calculating time period between 2 dates 3
Difference of time 3
difference between two dates 3
difference between dates 4
difference between dates 2
Hours difference 3
Length of time from date/time custom format 2

Top