VB converting to US date format ?

[Pauljj]

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

Cells(1, 9) = Day(Range("H1")) & "/" & Month(Range("H1") - 1) & "/" & Year(Range("H1"))

 

[FormR]

Hi, you could try:

Cells(1, 9) = cdate(Day(Range("H1")) & "/" & Month(Range("H1") - 1) & "/" & Year(Range("H1")))

Or probably a better option:

Cells(1, 9) = dateadd("m",-1,range("H1").Value)

 

[Pauljj]

I like it, thanks so much