Date format issue

[manish Joshi07]

HI,

I have one data in which dates are having the diffrent formats and when trying to change the date it is not reflecting.

I want to calculate the difference of date with respect to current date but due to some issue it is not happening.

Is any tool which can be used to make the date or time format in same manner.?

Sheet is attached for your ref.

[Pepe Le Mokko]

Col A and B are text looking like dates. Select the first column Data - Text to columns - Finish - Format as required
Same with the other

[manish Joshi07]

hi,

I have tried the same but not working

[shukla.ankur281190]

Hi Manish

Try

D2=ROUND(C2-TEXT(A2,"DD.MM.YYY HH:MM")+0,2)

[hemesh]

i think you can try
=C2+0-A2+0

and then set the formatting to the way you want

[manish Joshi07]

Thanks ankur but formula is not working

[manish Joshi07]

thnaks Hemesh but it is still not working

[hemesh]

if you want to have days difference post#5 formula will work
else you can use below
=DATEDIF(A2+0,C2+0,"D")

further details about datedif is at below
https://support.office.com/en-us/art...d-4a1e3d42bc1a

[hemesh]

manish find attached see this is working

[manish Joshi07]

hi it is working in your sheet but same formula is not working in my sheet.

Is any setting which need to done in my excel 2010.
pl suggest

[hemesh]

may be you need to check your calculation mode, as it may be set to manual
go to formula tab in last section see the calculation and set it to automatic

[manish Joshi07]

it is on Automatic mode only

[hemesh]

what error you are getting manish

[manish Joshi07]

HI no error reported. Only #value!

[Pepe Le Mokko]

My suggestion under post #2 works perfectly for me.
You can only apply this technique to ONE column at a time