Google Sheets Timestamp: Insert, Format, and Automate

To insert a fixed timestamp in Google Sheets, select a cell and press Ctrl+; to enter the current date, or Ctrl+Shift+; to enter the current time; on a Mac, use ⌘+; and ⌘+Shift+; respectively. For a timestamp that updates when the sheet recalculates, enter =NOW() instead—but that formula is not a permanent record of when you first entered it.

What a timestamp means in Google Sheets

A timestamp usually means a date and a time stored together, such as 11/03/2026 9:15 AM. People use timestamps to record when a request arrived, a task was completed, or a row was last updated. It is useful to distinguish a fixed timestamp from a formula result: the first stays as entered, while the second can change as the spreadsheet recalculates.

Google Sheets stores dates and times as numeric values. The date is represented by a day number, and the time is a fraction of a day. That is why a timestamp can be sorted, compared, subtracted, or used in calculations rather than being only a piece of text. Its displayed appearance depends on the cell’s number format and the spreadsheet’s time-zone settings.

Insert a fixed date or time with a shortcut

Keyboard shortcuts are the quickest way to enter a value that should stay fixed. Click the target cell, then use the shortcut for the value you need:

Current date: Ctrl+; on Windows or ChromeOS; ⌘+; on Mac.
Current time: Ctrl+Shift+; on Windows or ChromeOS; ⌘+Shift+; on Mac.

These shortcuts enter a value rather than a live formula, so later edits to other cells do not make the original entry advance. If you need both a date and time, you can enter them in separate cells, or use a date-time formula when a changing result is acceptable. The shortcut is convenient for manual logs, but it does not automatically stamp every row someone edits.

For example, a support team could keep the received date in column A and the received time in column B. A staff member selects the appropriate cell when recording each new request. Because the entries are fixed, sorting the log later will not change when the request was recorded.

Format the timestamp so it is readable

A cell can contain a valid date and time but display only the date, only the time, or a number. To change its appearance, select the cell or range and choose Format > Number, then select a date-time option. For more control, choose Format > Number > Custom date and time and select or build a format that includes the parts you want.

For instance, a format such as month/day/year followed by hours and minutes makes a log easy to scan; including seconds can help distinguish events recorded close together. Formatting changes how the value looks, not the underlying timestamp. If you need seconds for an audit trail, remember that display precision does not make the capture method more reliable or establish who made the change.

If a cell shows a decimal number, it may still contain a valid timestamp. Apply a date-time format before assuming the value is broken. Conversely, typing a date-like phrase that Sheets cannot recognize may leave text in the cell. Text does not behave like a true date-time value in sorting and arithmetic, so check the cell format and test a calculation if the distinction matters.

Use NOW or TODAY for formula-based results

Enter =NOW() in a cell to display the current date and time. Use =TODAY() when you need only the current date. Both are useful for dashboards, reports, and calculations that should reflect the current day or time, but neither is a dependable way to preserve the original time a row was created. They recalculate according to the spreadsheet’s recalculation settings and other recalculation events.

For example, if a task description is in B2 and you put =IF(B2<>"",NOW(),"") in A2, A2 can show the current date and time when B2 is nonblank. However, it is not a one-time stamp: the result can change when Sheets recalculates. Use this pattern for a live indicator, not for a permanent “created at” record.

To control how often volatile formulas recalculate, open File > Settings > Calculation and review the recalculation options. The available choice affects how frequently formulas such as NOW update. A setting that recalculates more often can make a live clock or dashboard feel more current, but it can also cause dependent results to update more frequently. It does not turn NOW into a fixed value.

Automatically stamp a row when it is edited

Google Sheets does not provide a standard cell formula that both detects an edit and permanently writes the time of that first edit without using a circular-reference workaround. A common way to create a fixed automatic timestamp is a small Google Apps Script triggered by a user edit. This is helpful for simple intake or status logs, but it should be tested on a copy before being used for an important record.

Suppose column B contains an entry and column A should receive a timestamp the first time that entry is made. Open Extensions > Apps Script, add the code below, change the sheet name if needed, and save the project. The script ignores the header row, watches only column B, and leaves an existing timestamp alone.

function onEdit(e) {
  const range = e.range;
  const sheet = range.getSheet();

  // Change Sheet1 if your tab has a different name.
  if (sheet.getName() !== 'Sheet1') return;
  if (range.getRow() < 2 || range.getColumn() !== 2) return;
  if (range.getNumRows() !== 1 || range.getNumColumns() !== 1) return;

  const value = range.getValue();
  if (value === '') return;

  const stampCell = sheet.getRange(range.getRow(), 1);
  if (stampCell.getValue() === '') {
    stampCell.setValue(new Date());
  }
}

This simple on-edit trigger responds to a person editing the sheet; it does not run just because a formula result changes, and it does not respond to edits made by another script or an API. The example also deliberately ignores multi-cell pastes. If your workflow needs timestamps for pasted rows, edits to multiple columns, or a “last modified” time that updates on every change, the script needs different logic. Apps Script permissions and organizational policies may also affect whether it can be used.

Check the spreadsheet time zone and sharing context

A timestamp’s displayed local time can depend on the spreadsheet’s time zone. To review it, open File > Settings and check the time-zone setting. This matters when collaborators work in different regions: the same stored moment may appear differently depending on the spreadsheet’s settings and the way a date-time value is displayed.

For a shared log, decide on one time zone and tell users what it is. A value shown as 9:00 AM is hard to interpret if some people assume their local time and others assume the team’s operating time. If the sheet supports a process with strict recordkeeping requirements, document who can edit the timestamp column and how corrections are handled. A spreadsheet timestamp alone is not a tamper-proof audit trail.

Common timestamp problems and how to avoid them

The time changes later: Check whether the cell contains =NOW() or another formula. Use a shortcut or a script that writes a value when you need a fixed entry.
Only the date appears: Apply a date-and-time number format using Format > Number. The time may be present even if the current format hides it.
The value looks like a decimal: Format it as a date or date-time. Sheets stores dates and times numerically, so an unformatted value may not look familiar.
Sorting gives unexpected results: Check whether entries are real date-time values or text. Mixed text and numeric values can sort differently from a consistent timestamp column.
A script did not stamp a row: Confirm the tab name, watched column, header-row assumption, and whether the edit was a single-cell user edit. The sample script intentionally does not handle multi-cell pastes.

Do not confuse a timestamp with a duration. A timestamp identifies a point in time; a duration measures the interval between two points. If A2 and B2 contain valid start and end timestamps, subtracting the earlier time from the later one produces a duration value, which should be formatted as a duration when it may exceed 24 hours. Formatting that result as an ordinary clock time can make a long interval appear to wrap around.

Google Sheets timestamps compared with Excel

Google Sheets and Excel both store date-time values numerically and offer volatile current-date or current-time functions, so the basic distinction between a fixed entry and a recalculating formula applies in both. However, keyboard shortcuts and automation tools are application-specific. Do not assume a Sheets shortcut, Apps Script, or menu path works the same way in Excel; Excel has its own shortcuts and automation options, including Office Scripts in supported environments and VBA in desktop editions.

For a small shared log in Sheets, manual shortcuts may be enough. For repeatable automatic stamping, Apps Script can respond to edits, subject to its trigger limits and permissions. For compliance-sensitive records, neither a formula nor a simple edit trigger should be treated as an immutable audit system. Choose the method based on whether you need convenience, a live calculation, a fixed value, or stronger controls over changes.

Frequently Asked Questions

How do I insert the current date and time in one Google Sheets cell?
Use =NOW() for a date and time that can recalculate. For a fixed manual entry, use the date and time shortcuts; because shortcuts enter date and time separately, check the resulting cell format and workflow if both must be captured together as one permanent value.

Does NOW stay fixed after I enter it?
No. NOW is a volatile function and can update when the sheet recalculates. Use a keyboard shortcut for a fixed manual value or an appropriately designed Apps Script for an automatic fixed timestamp.

Can Google Sheets timestamp a row automatically when I type in it?
Yes, a Google Apps Script on-edit trigger can write a date-time value to another cell when a user edits a row. A formula alone does not reliably preserve the first edit time, and trigger behavior depends on how the edit is made.

Why does my timestamp show only a date?
The cell may be formatted to display the date but hide the time. Select it and choose a date-time format through Format > Number, or customize the display with Format > Number > Custom date and time.

Will collaborators see a timestamp in their own local time?
Do not assume so. The spreadsheet has a time-zone setting that affects how date-time values are interpreted and displayed. Check File > Settings and agree on a time zone for shared records.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.