This document, titled « Excel- Convert the date format into general format », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
Thanks for formula.
As an alternative to the Date picker control, I created a userform to enter dates into the active cell. Date can be entered in the cell in two formats as dd.mm.yyyy and mm.dd.yyyy. Also, the date in the cell can be changed according to these two formats.
Day and month names are generated according to the user's system language.
As an alternative to the Date picker control, I created a userform to enter dates into the active cell. Date can be entered in the cell in two formats as dd.mm.yyyy and mm.dd.yyyy. Also, the date in the cell can be changed according to these two formats.
Day and month names are generated according to the user's system language.
I hope it will be useful to you.
Source : https://eksi30.com/add-date-to-cell-easily-with-excel-userform/