Shabbo I wanted to convert my data to dates as (DD-MM-YYYY).
... above seems to work ...
... and now ... I wanted to get result like highlighted in yellow but it’s not coming.
... do You would like to get only day - out from date?
... if so ... then eg for cell C2 =day(a2)
Excel seems to work well - You just need to tell to Excel - what do You would like to get?