MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
When I run the code, I am facing a date issue in the destination sheets. The dates are converted from the source sheet from dd/mm/yyyy to mm-dd-yyyy in some of the rows. Can someone please help me correct the code to get the right dates. For instance, in the second row the date 03/01/2022 is converted to 01-03-2022. This is just one date. There are multiple dates which start from day 1 to 12 are all converted to months. Please note this was posted in another forum and I haven't come across any working solution for the above.