How to format a date in a Google sheet



1 comment

  • Avatar
    Andel Koester

    FYI, this solution does not work if you are trying to modify the format of dates in a Custom Report Builder export of Activities from Opportunities. In this export, the date for each activity comes out as follows: "November 5, 2018 9:07:21 AM PST", and Google Sheets does not recognize this as a date no matter what number format you choose. 

    The solution I found is:

    1) Use SUBSTITUTE to swap the third space for a semicolon. You have to do this in order to get a unique delimiter for the next step.

    2) Use SPLIT to split the column by the semicolon.

    This will leave you with a useable date format. 

Please sign in to leave a comment.