Convert datevalue to "d-mmm-yy"

[chelseaaa]

I want to convert Startday to "d-mmm-yy" format but I always get "mm-dd-yyyy".

Can someone help me?

This is the VBA code:

FinalRow = Cells(Rows.Count, 4).End(xlUp).Row
For I = 2 To FinalRow
startday = DateValue(Left(Cells(I, 4), 10))
startdate = Format(startday, "d-mmm-yy")

Next I

 

[mikerickson]

startday is data type Date and has no format.
startdate is a string and should show in the proper format

How are you outputting startday and startdate?

 

[chelseaaa]

startday is data type Date and has no format.
startdate is a string and should show in the proper format

How are you outputting startday and startdate?

Thanks mikerickson it worked sooo great. U are really goooood.