ChrisFoster
Board Regular
- Joined
- Jun 21, 2019
- Messages
- 246
- Office Version
- 365
- Platform
- Windows
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
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