Forum Discussion
Solved
VBA date formatting regardless of regional setting
Here is an extract of my vba codes: Dim dtToday As Date Dim CurrTime As String Dim Rng As Range dtToday = Date() 'today date CurrTime = Time() 'current time Rng.Offset(1).Value = Format(Da...
I tested your proposed solution with a few different desktop regional settings. It gave the same result, a consistent date in dd/mm/yyyy format that I'm looking for.
Thank you for this quick and simple solution.
