Table of Contents
Converting a timestamp to a date in Google Sheets is a simple process that involves using the built-in functions available in the program. A timestamp is a numeric value that represents a specific date and time, while a date is a specific day within a calendar. To convert a timestamp to a date in Google Sheets, one can use the “DATE” function which allows for the conversion of a timestamp to a date format. This function takes in three arguments: the year, month, and day that make up the timestamp. By inputting these values, the function will automatically convert the timestamp to a recognizable date format. This feature is useful for organizing and analyzing data that contains both timestamps and dates, making it easier to track and interpret information accurately.
Convert Timestamp to Date in Google Sheets
You can use the following formulas in Google Sheets to quickly convert a timestamp to a date.
Formula 1: Use DATEVALUE
=TO_DATE(DATEVALUE(A1))Formula 2: Use INT
=TO_DATE(INT(A1))Both formulas convert the timestamp in cell A1 to a date.
The following examples show how to use these formulas in practice.
Example 1: Convert Timestamp to Date Using DATEVALUE
The following screenshot shows how to use the DATEVALUE function to convert the timestamp values in column A to date values in column B:
Notice that only the date is shown in column B and the time has been removed.
Example 2: Convert Timestamp to Date Using INT
The following screenshot shows how to use the INT function to convert the timestamp values in column A to date values in column B:
Notice that only the date is shown in column B and the time has been removed.
Also notice that this formula returns the exact same results as the previous formula.
Additional Resources
Cite this article
stats writer (2024). How do I convert a timestamp to a date in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-convert-a-timestamp-to-a-date-in-google-sheets/
stats writer. "How do I convert a timestamp to a date in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-convert-a-timestamp-to-a-date-in-google-sheets/.
stats writer. "How do I convert a timestamp to a date in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-convert-a-timestamp-to-a-date-in-google-sheets/.
stats writer (2024) 'How do I convert a timestamp to a date in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-convert-a-timestamp-to-a-date-in-google-sheets/.
[1] stats writer, "How do I convert a timestamp to a date in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I convert a timestamp to a date in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.