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! ^^
Bookmarks