Prevost
Board Regular
- Joined
- Jan 23, 2014
- Messages
- 198
Hi There,
I am trying to extract the date from this text in a cell
10/1/14 12:00:00 AM EDT
The EDT doesn't need to be included. I then want to extract from the date the year, month, day and time (which I can do with formulas).
It's just extracting the date that I need help with. I am okay with using VBA as the solution!
Thanks,
I am trying to extract the date from this text in a cell
10/1/14 12:00:00 AM EDT
The EDT doesn't need to be included. I then want to extract from the date the year, month, day and time (which I can do with formulas).
It's just extracting the date that I need help with. I am okay with using VBA as the solution!
Thanks,