In sheet the column 3 with with "dates" looks like:
03.08.2012 04.08.2012 05.08.2012 ........
So firstly before doing something operations on it or compare those dates with actual date i wanted to convert it to proper format like is on my compuer (yyyy-MM-dd) so i tried to use: Convert.todate, cdate and format() but with no success. I tried firstly
and after that would like to change format by use Format(), but i couldnt do the above first to get all those dates and convert to date/ How should i do this?