Hello!
I am a beginner when it comes to creating formulas in Excel.
I have a column which consists of date and time in the same cell.
Original data:
2015-07-25 00:00:00 UTC
What I am trying to do is come up with a formula to change the date format to MM/DD/YYYY and not use the time stamp at all.
New format after formula:
7/25/2015
Any insights will be much appreciated!
Thank you so much in advance!
Carol
Bookmarks