vba - change column "type"

[MJ]

Hi,

I have a csv that gets opened in excel. One column contains cells
with the format of Date (mm/dd/yyyy). I need to get the difference
between this date and the date in another column. My problem is that
the format of the other column is shown as "Custom" (m/d/yyyy h:mm).

Is there a way to get the custom column to be the same format as the
first column so that I can do a datediff?

Thanks,
MJ

 

[Frank Kabel]

Hi
if these values are both stored as real date values you can simply use
=DATEDIF(INT(A1),INT(A2))