Date showing mm-dd-yyyy instead of dd-mm-yyyy

I am trying to write a date in "dd-mm-yyyy" format in excel sheet thru excel-vba. I achieved it using [a2].CurrentRegion.Columns("k").NumberFormat = "dd-mm-yyyy”
and my cell value comes out to be 17-02-2021 , which is good.....
But there is some weird problem... Since I have to iterate the startDate for whole month by everytime adding it by 1, so the next value comes out to be 02-01-2021 instead of 01-02-2021 until 12th of each month 12-02-2021 and from 13th, the month is again changing to two digits 13-02-2021

Please Login or Register  to view this content.

kirana,

This works on mine:

Please Login or Register  to view this content.

Ochimus

cross posted : https://www.mrexcel.com/board/thread...-yyyy.1162418/

kirana2014, when you cross-post it is required to include links. Mr. Excel has the same rule. You have GlennUK to thank for posting it for you.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.