ChrisFoster
Active Member
- Joined
- Jun 21, 2019
- Messages
- 252
- Office Version
- 365
- Platform
- Windows
I have an excel document where in column H is a list of dates, I am not concerned with the year though so want to change the date in each cell to the current year.
So for example I have a date of 20/05/2012, I want that to change to 20/05/2024. I am in the UK hence why using UK date format.
I can manually use Text to Columns to do this but isn't the best way when using VBA.
What is the best VBA code to do this please?
So for example I have a date of 20/05/2012, I want that to change to 20/05/2024. I am in the UK hence why using UK date format.
I can manually use Text to Columns to do this but isn't the best way when using VBA.
What is the best VBA code to do this please?
