Hi, I have the following: 01/10/2021 5:37pm ET This of course changes every day, both the time and date and year.
I'm looking for VBA code to extract only the date(in this case 01/10/2021) and be able to cope with the changing dates/time/year.
I've tried lots of different code but can't seem to get it.
I have this: "01/10/2021 5:37pm ET" BUT need this: "01/10/2021"
Thanks!
I'm looking for VBA code to extract only the date(in this case 01/10/2021) and be able to cope with the changing dates/time/year.
I've tried lots of different code but can't seem to get it.
I have this: "01/10/2021 5:37pm ET" BUT need this: "01/10/2021"
Thanks!