Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Sir,
I stuck a requirment. In my raw data my date format is 20.11.2016. in text format. how i convert in number format and proper date format.
My Date Format from sourceTo is=20.11.2016
i Want to this=20/11/2016
For this i am sharing a excel.
=Date(Date#(sourceTo, 'dd.MM.yyyy'), 'dd/MM/yyyy')
=Date(Date#(sourceTo, 'dd.MM.yyyy'), 'dd/MM/yyyy')