Current Date in Google Sheets: A Practical Guide to TODAY and DATE Functions

What is the TODAY function and why current date matters

In Google Sheets, the TODAY function returns the current date. According to How To Sheets, the TODAY function is the simplest way to pull in the current date in Google Sheets. The formula is simple: =TODAY(). It is a volatile function that recalculates whenever the sheet recalculates, so the value shown will update as days pass or when you open the file again. This makes TODAY ideal for time-aware templates, dashboards, and date-based calculations that need to reflect today without manual edits. Because TODAY returns a date value (not text), you can perform date arithmetic like TODAY() + 7 to find dates a week from now. If you need a fixed date, avoid TODAY and enter a static date or copy the result and paste as values. You can also combine TODAY with the TEXT function to control how the date looks, for example =TEXT(TODAY(), "dddd, MMMM d, yyyy"), which shows a friendly readable form. To try it, type =TODAY() in a blank cell and press Enter; you will see today’s date update automatically as needed.

Formatting the current date for readability

Dates are most useful when they’re easy to read. The TEXT function lets you format TODAY’s result in any human-friendly style. For example, =TEXT(TODAY(), "dddd, MMMM d, yyyy") displays a full date like Wednesday, March 14, 2026. Locale settings influence month and day names, so adjust your Google Sheets locale if you need a different language or date order. You can also use formats like "yyyy-MM-dd" for consistency in logs or data imports. Keep in mind that TEXT returns text, so you can’t perform pure date arithmetic on the formatted result without referencing TODAY again. Experiment with common styles, such as "MMM d" for short forms or "EEEE" for the day name, to suit your templates and dashboards.

Time zone, recalc behavior, and workbook settings

TODAY’s value is tied to the time zone of the Google Sheet. If your team spans multiple regions, confirm the spreadsheet time zone under File > Settings, then apply the same setting across related sheets. Recalculation happens on edits or when opening the file, so TODAY updates at those moments. If you paste TODAY’s value as plain text or as a static date, the dynamic link is lost. For time-sensitive workflows, keep TODAY dynamic and only convert to static when you intentionally want a fixed snapshot. You can also combine TODAY with DATEVALUE if you ever need to convert text dates back to date values for calculations.

Practical uses in templates and dashboards

Dynamic dates power a wide range of templates. A simple due date example is to compute a date two weeks from today: =TODAY() + 14. You can build a status tracker that flags overdue items with =IF(TODAY() > DueDate, "Overdue", "On track"). When you share dashboards with teams, TODAY helps ensure that deadlines and milestones reflect the current day without manual updates. If you’re logging events, add a header like "Report date" linked to TODAY so each export carries the current date. For documentation and audit trails, pair TODAY with TEXT to present readable dates in reports without losing the underlying date for calculations.

Date arithmetic in Google Sheets

Beyond simple today values, several date functions expand what you can do with TODAY. Use =EDATE(TODAY(), 1) to move one month forward, or =EDATE(TODAY(), -2) to go back two months. For month-end analysis, =EOMONTH(TODAY(), 0) yields the end of the current month, while =EOMONTH(TODAY(), 6) gives the end six months from now. Combine with WEEKDAY to identify workdays, or NETWORKDAYS to count business days between today and a future date. These techniques support planning calendars, billing cycles, and project timelines without manual date management.

TODAY vs NOW and timestamps

TODAY returns only the date portion, while NOW returns both date and time. If you need a time stamp that freezes, TODAY should be used in conjunction with value-saving steps like copy-paste as values or using a script to capture a moment in time. When you want a time-stamped label that updates on reopen, NOW with a fixed format can approximate a timestamp, but be mindful that NOW also recalculates and can move forward when you don’t expect it.

Common mistakes and fixes

A common mistake is treating TODAY as a static date after copy-pasting to another cell. Always reference TODAY directly or re-derive the date when you need current values. Another pitfall is formatting the result with TEXT and then performing date arithmetic on the formatted text; always keep the arithmetic on the date value (TODAY) and format for display. If a date shows as text, convert it with DATEVALUE or wrap calculations in DATEVALUE when importing data from other sources. Finally, ensure your locale and time zone settings align with your team’s expectations to avoid confusion when the sheet is shared across regions.

Troubleshooting date issues in Google Sheets

If dates appear inconsistent, check the sheet locale and time zone under File > Settings. Dates formatted as text can break calculations; convert with DATEVALUE or re-enter the date using a date-formatted cell. When dates do not update, ensure the workbook is recalculating (some settings or add-ons can affect recalc). If you import data, verify whether the source uses ISO formats or local formats and adjust with TEXT or DATEVALUE accordingly.

Quick-start checklist and best practices

• Use TODAY for dynamic date references in templates
• Pair TODAY with TEXT for friendly formats
• Keep time zone consistent across related sheets
• Do date arithmetic with TODAY as the base rather than text
• Avoid converting TODAY to static values unless intentional
• Document your formatting choices for collaborators

],