Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert a timestamp to just a date in Excel and Google Sheets
Excel & Google Sheets
=INT(A2)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Paste or import your timestamps into column A (e.g., '2024-03-15 14:35:22').
- 2In B2 enter =INT(A2) — INT drops the decimal (time) portion, keeping only the integer date serial.
- 3Format column B as Date (Short Date) to display the result as a readable date.
- 4Alternatively use =TRUNC(A2) — it behaves identically for positive date values.
Tips
- If your timestamps are stored as text strings, first convert with DATEVALUE and TIMEVALUE or use =INT(DATEVALUE(TEXT(A2,"YYYY-MM-DD"))) depending on the format.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is the difference between INT and TRUNC here?
For positive dates they're identical. TRUNC truncates toward zero; INT rounds toward negative infinity — both give the same result for valid dates.
My timestamp is a text string — how do I convert it?
If the text is in a recognizable format use =DATEVALUE(LEFT(A2,10)) to extract just the date part from a YYYY-MM-DD HH:MM:SS string.