How do I change this date (Nov 1, 2017 1:57:53 PM PDT) to 11/1/17?

Hi Christine,

Try to use this formula:

=DATEVALUE(SUBSTITUTE(A2,"PDT",""))

You may get the dates in the serial number mode as shown in the above screenshot, in this case, you can convert the format of the cells to the date format that you want as follows:

Step 1

Highlight all the cells that contain these serial numbers, then press Ctrl + 1.

Step 2

Select Date Category.

Step 3

Choose the type that you prefer, then hit OK.

Hope this helps.