How to Convert Timestamp to Date in Google Sheets

To convert a timestamp to a date in Google Sheets, you can use the TO_DATE() function. This function takes a timestamp value as an argument and returns the corresponding date. Here's a step-by-step guide on how to do this:

1. Open your Google Sheet.
2. Click on an empty cell where you want to display the date.
3. Type the following formula, replacing 'A1' with the cell containing the timestamp you want to convert:=TO_DATE(A1)Note: If your timestamp is in milliseconds, you need to divide it by 1000 before using the TO_DATE() function, like this:=TO_DATE(A1/1000)
4. Press Enter.

The date will now be displayed in the selected cell.

Example

Let's say you have a timestamp in cell A1, and you want to convert it to a date in cell B1.

1. Click on cell B1.
2. Type the following formula:=TO_DATE(A1)Or, if your timestamp is in milliseconds:=TO_DATE(A1/1000)
3. Press Enter.

Cell B1 will now display the date corresponding to the timestamp in cell A1.