Using VBA for date formatting

[dh1996]

Hey again,

i'm trying to format some dates using vba, generally it's easy enough, i can take dd-mm-yyyy to dd-mmm, but sometimes things go over two dates, for example, dd/dd-mm-yyyy and i want to take it to dd/dd-mmm, but since it's not a 'real' date then i can't get it to work properly.

i'm using an import to another sheet, so the date on one sheet will be as an example - 18/19-03-2025, and i want that to become 18/19-March on another sheet.

any help is appreciated!

 

[Joe4]

If you have "18-19-03-2025" in cell A1, this VBA code will return "18/19-March":

Left(Range("A1"), 6) & Format(DateValue(Right(Range("A1"), 10)), "mmmm")

 

[dh1996]

If you have "18-19-03-2025" in cell A1, this VBA code will return "18/19-March":

Left(Range("A1"), 6) & Format(DateValue(Right(Range("A1"), 10)), "mmmm")

i will give it a try now thanks! i had tried using left and mid but i got something wrong and kept receiving and error

 

[dh1996]

If you have "18-19-03-2025" in cell A1, this VBA code will return "18/19-March":

Left(Range("A1"), 6) & Format(DateValue(Right(Range("A1"), 10)), "mmmm")

perfect, thanks!

 

[Joe4]

You are welcome.
Glad I was able to help!