Day and Month of the date switched!

[kisa159]

Hello everybody!

I have an array (array_Week) that contains multiple dates inside. When I look at the codes in debug mode, I notice that the date is in correct format (d/m/yyyy), yet when i output on to a range, the day and month switched.

I tried NumberFormat and NumberFormatLocal the range but it still comes out wrong.
I also tried formatting every single date inside the array, but it still comes out wrong.
I can't convert it to double because i have to use the date and compare it with the dates in my data excel files.

Please help me.

Edited:

Hello! Just in case other people or future me would need a solution to this problem, I decided to write down the solution I found.

I managed to solved it by making another array to contain the date in number format, then i output that array on the range and NumberFormatLocal the range! ^^

[Norie]

How are you outputting it to the range?

[kisa159]

This is the code for output

Range("i_selectionlist1") = WorksheetFunction.Transpose(arrayWeek)