Morning all,
I am using this code but as a result it is treating the month as a day and the day as a month.
I need it to appear as UK date format ....any ideas please
I am using this code but as a result it is treating the month as a day and the day as a month.
I need it to appear as UK date format ....any ideas please
Code:
Cells(1, 9) = Day(Range("H1")) & "/" & Month(Range("H1") - 1) & "/" & Year(Range("H1"))