mtkalman
03-01-2017, 02:29 AM
Hey there
I have to transfer dates from a report to another sheet.
The report has the dates in dd.mm.yyyy format, and i need them in yyyy.mm.dd
So far i managed to get them into the desired form, but there comes the problem!
If the day number is 12 or lower the exccel treats that as the month.
for example, if i have 13.02.2016 it works perfectly and gives me 2016.02.13
but if i have 07.02.2017 it gives me 2017.07.02
Worksheets("Aktual").Cells(var, 5).Value = Format(Cells(iRow, 2), "yyyy/mm/dd")
this is the line im usig to get what i need.
any suggestions?
Thank you !
I have to transfer dates from a report to another sheet.
The report has the dates in dd.mm.yyyy format, and i need them in yyyy.mm.dd
So far i managed to get them into the desired form, but there comes the problem!
If the day number is 12 or lower the exccel treats that as the month.
for example, if i have 13.02.2016 it works perfectly and gives me 2016.02.13
but if i have 07.02.2017 it gives me 2017.07.02
Worksheets("Aktual").Cells(var, 5).Value = Format(Cells(iRow, 2), "yyyy/mm/dd")
this is the line im usig to get what i need.
any suggestions?
Thank you !