I have a Google spreadsheet file and I need to convert the date column from this format:
Sun, May 4, 2014 4:30PM to this format:
mm/dd/yyyy. Basically, I need the date to be in a simple format and take out the “day” and “time”.
How can I do this?
Here is the link to the spreadsheet: