Incorrect date sorting. Excel 2013

[Kamil Khatib]

Hi,

I have a problem sorting by date, i tried the Cell Format thing and also the Text to Columns to identify cells as Date cells , but nothing worked still cells are sorted incorrectly.

Anyone can help and tell me how it gonna work?

FYI, 

[#2]

Kamil,

check ISTEXT(C2).

[#3]

Mr. Kamil

I observed in your worksheet that there are 'merged rows', could this be the source of your problem?

HTH