How to Add a Date in Google Sheets: Every Method Explained

Google Sheets gives you more ways to add dates than most people realize — from typing one manually to generating them automatically with formulas. Which approach works best depends on what you're actually building: a simple log, a project tracker, a form that timestamps itself, or a dashboard that always shows today's date.

Here's a complete breakdown of every method, what each one does, and the factors that change which approach makes sense for your situation.

The Basics: Typing a Date Manually

The most straightforward method is typing a date directly into a cell. Google Sheets recognizes most common date formats automatically and converts them into a proper date value — meaning Sheets stores the date as a number internally, which lets you sort, filter, and calculate with it.

Common formats Sheets recognizes:

• 1/15/2025
• January 15, 2025
• 15-Jan-2025
• 2025-01-15 (ISO format)

Once entered, Sheets formats the date based on your spreadsheet's locale settings. If dates look wrong — month and day swapped, for example — check your locale under File → Settings → General → Locale.

⚠️ If a date appears as a plain number (like 45672), the cell is formatted as a number, not a date. Fix this by selecting the cell and going to Format → Number → Date.

Keyboard Shortcuts for Today's Date and Current Time

Google Sheets has two built-in shortcuts for inserting a static date or time — meaning the value is fixed and won't change when the spreadsheet recalculates.

These shortcuts are useful for manual logging — timestamping when a task was completed, when a record was entered, or when a status changed. Because they're static, they don't update automatically, which is exactly what you want for an audit trail.

Dynamic Dates with Formulas

If you need a date that updates automatically, formulas are the right tool.

=TODAY()

Returns the current date and updates every time the spreadsheet recalculates (typically every time it's opened or edited).

Use cases: dashboards showing how many days until a deadline, age calculators, conditional formatting rules that highlight overdue items.

=NOW()

Returns the current date and time. Like TODAY(), it recalculates automatically.

Use cases: audit logs where time matters, dashboards showing the last refresh time.

Important distinction 🗓️

TODAY() and NOW() are volatile functions — they change. If you need a permanent timestamp, use the keyboard shortcuts above or a script-based approach. Using NOW() as a log entry will overwrite your historical timestamps every time the file opens.

DATE Formula: Building Dates from Parts

The =DATE(year, month, day) function constructs a date from three separate values. This is especially useful when your year, month, and day data lives in separate columns, or when you're calculating dates programmatically.

Example: =DATE(2025, 6, 1) returns June 1, 2025.

You can also combine it with arithmetic:

• =DATE(2025,1,1) + 30 → returns January 31, 2025 (30 days after Jan 1)
• =EDATE(A1, 3) → returns the date 3 months after whatever date is in A1

These formula-based approaches become important in project planning, billing cycles, and subscription tracking where relative dates matter more than hardcoded ones.

Auto-Populating Dates with Google Apps Script

For spreadsheets that need dates added automatically when a row is edited or a form is submitted, a lightweight Apps Script can insert a timestamp without any user action.

This approach sits inside Tools → Apps Script and uses a trigger (like onEdit) to write the current date into a specific column whenever another column is updated.

The tradeoff: Apps Script requires basic familiarity with JavaScript syntax and some understanding of how triggers work. It's powerful but adds complexity — a bug in the script can cause unexpected behavior across the sheet.

Formatting Dates the Way You Need Them

Adding a date is only half the job — displaying it correctly is the other half.

Google Sheets lets you apply custom date formats under Format → Number → Custom date and time. You can display the same underlying date value as:

• 01/15/2025
• Wednesday, January 15
• Jan 15
• 2025-01-15

This matters when sharing sheets with others who expect a specific format, or when exporting data to systems that require a particular date structure (like ISO 8601 for API integrations).

Variables That Affect Which Method Is Right

The "best" way to add dates in Google Sheets isn't universal — it shifts based on several factors:

Static vs. dynamic need: Do you need the date locked in place (a log), or should it reflect today every time someone opens the file (a dashboard)?

Manual vs. automated entry: Are you entering dates yourself, or do they need to populate based on user actions or triggers?

Skill level and maintenance tolerance: Apps Script is more capable but requires ongoing maintenance. Formulas are more portable and require no coding.

Downstream use of the data: If dates feed into calculations, charts, or other formulas, how the date is stored (true date value vs. text string) matters a great deal. A date typed as plain text — like "Jan 15" without quotes — won't behave like a date in formulas.

Locale and regional format differences: Shared spreadsheets across different regions can produce date confusion if locale settings aren't aligned between collaborators.

Most people find themselves mixing methods — a TODAY() formula for the header, static shortcuts for log entries, and DATE() functions for calculations. Whether that combination works cleanly depends on how the rest of your sheet is structured and what you need the dates to actually do.