Formula or VBA code needed

[ChrisFoster]

Hi all,

I currently have lots of dates in column A, the current format is dd/mm/yyyy (UK not US).
I need those dates to show in column B as 01/mm/yyyy, so the day is always 01 followed by the specific month and year.

I currently do this by converting the date to text as mm/yyyy then use the Datevalue function to put it back to date format.

Is there any formula or line of VBA code that I can use to just do this in one go?

Kind Regards,

Chris

 

[Peter_SSs]

Try

=A2-DAY(A2)+1

 

[ChrisFoster]

Try

=A2-DAY(A2)+1

Thank-you, that has worked perfectly.

 

[Peter_SSs]

You're welcome.