changing the date format

[nburton]

I am working on a macro that at one point copies a date from sheet a to a sheet b. However, I need to change the date format from A to B. Currently sheet A has the format as yy-month, (in written form it looks like 16-May). I need it to be in mm/dd/yyyy when it copies to sheet B. I want the day to be "15". so for the example given 16-May would be pasted into sheet B as 05/15/2016. Is this possible? What I had previously reads the data as 5/16/16. Any help would be appreciated.

ddate = Cells(2, j).Value

 

[JoeMo]

If the date in sheet A is a true date (serial date number) you can use:

ddate = Format(Cells(2, j).Value,"mm/dd/yyyy")

 

[nburton]

this worked thank you!

 

[JoeMo]

this worked thank you!

You are welcome - thanks for the reply.