How to Insert Today's Date in Excel: The Complete 2026 Guide to TODAY, NOW, and Dynamic Date Functions

Knowing how to insert today's date in Excel is one of those foundational skills that quietly powers thousands of professional workflows, from invoice generation to project timelines and audit logs. Whether you're tracking aging receivables, stamping when a record was last updated, or building a dashboard that always reflects the current day, Excel gives you several methods to handle this task. Some methods produce a static date that never changes, while others recalculate every time the workbook opens, and understanding the difference is critical to building reliable spreadsheets that behave predictably.

The two most popular functions for this purpose are TODAY() and NOW(), and they sit alongside keyboard shortcuts like Ctrl+; and Ctrl+Shift+; that let you stamp the current date or time instantly. Each approach has trade-offs related to volatility, formatting, and how the value behaves when the file is reopened tomorrow, next week, or next year. Choosing the right method depends on whether you want a permanent record or a live, self-updating reference that always shows the current calendar day.

This guide walks through every reliable way to insert today's date in Excel, from the simplest keyboard shortcut to advanced formulas that combine TODAY with text, conditional formatting, and lookup functions. We'll cover how to format the result so it displays as Tuesday, May 22, 2026 instead of a five-digit serial number, how to freeze the value so it does not change tomorrow, and how to combine date functions with other tools you may already use in your daily work.

Excel stores dates internally as sequential serial numbers starting from January 1, 1900, which is day 1. Today, May 22, 2026, is serial 46,164. This numeric foundation is what makes date arithmetic possible — you can subtract two dates to get the number of days between them, add 30 to a date to get a deadline, or compare two dates with greater-than and less-than operators. Without this serial system, none of the powerful date logic in Excel would work the way it does.

Beginners often run into surprises when a date appears as a number, when TODAY changes overnight, or when copying a formula breaks the result entirely. These are not bugs — they reflect how Excel handles volatile functions and number formatting. By the end of this guide you'll know exactly which method to use for which scenario, how to troubleshoot the most common errors, and how to combine date functions with broader spreadsheet techniques used in finance, operations, and analytics teams worldwide.

If you also want to sharpen related skills, our broader Excel coverage explains a wide range of formulas and shortcuts. Many readers come here looking for date stamping but quickly graduate to building dynamic reports with VLOOKUP, INDEX/MATCH, and conditional logic — all of which interact beautifully with date fields. You can deepen those skills by exploring more topics across the Excel category on this site after finishing this article.

By the time you finish reading, you'll be able to insert today's date in Excel five different ways, format it for any audience, and decide intelligently when to use a static stamp versus a live formula. Let's start with the fastest method anyone can learn in under ten seconds.

The TODAY function and the NOW function are the workhorses of Excel date insertion, but they behave in subtly different ways that trip up even experienced users. TODAY() returns just the date portion — May 22, 2026 — with the time set to midnight. NOW() returns the date plus the current clock time, so it might read 2:47:13 PM on May 22, 2026. Both functions take zero arguments and live inside empty parentheses, and both are classified as volatile, meaning Excel recalculates them every time anything changes in the workbook.

Volatility matters more than people realize. If you have 50,000 rows containing =TODAY() and you edit a single unrelated cell, Excel recalculates every one of those TODAY formulas. On smaller spreadsheets this is invisible, but on enterprise workbooks with thousands of volatile cells, it can introduce a noticeable lag. The fix is simple: only use TODAY where you genuinely need a live date, and convert other instances to static stamps using Ctrl+; or paste-special-values once the value is captured.

Another quirk is the midnight behavior. If you open a workbook at 11:58 PM with =TODAY() in cell A1, then look back at 12:02 AM, the date has silently rolled over to the next day. This is desirable for live dashboards but catastrophic for invoices or signed records. Anytime the value must remain anchored to a specific moment, choose the static keyboard shortcut or convert the formula to its value once captured. Treat volatility as a feature, not a bug, but stay aware of when it bites.

You can combine TODAY with other functions to produce powerful results. =TODAY()-A2 returns the number of days between today and a date in A2, which is the foundation of aging reports. =YEAR(TODAY()) extracts the current year, useful for filtering or grouping. =TEXT(TODAY(),"dddd, mmmm d, yyyy") returns a string like Friday, May 22, 2026 — perfect for letter headers or printable reports. These compositions are where TODAY moves from a curiosity to an everyday workhorse.

The NOW function is essentially TODAY plus a time component. You can extract just the time by subtracting the integer portion: =NOW()-INT(NOW()) returns the fractional day, which Excel can format as hh:mm:ss. This trick is helpful when you want to log the precise moment of an event without modifying the cell format manually. It also pairs well with conditional formatting that highlights rows updated in the last hour.

Date arithmetic in Excel is decimal-based, so one day equals 1.0, one hour equals approximately 0.04167, and one minute equals roughly 0.000694. Once you internalize this, you can build elapsed-time calculators, countdown widgets to a deadline, and rolling 30-day windows for KPI reporting. Understanding the math under the hood demystifies why a date sometimes shows up as 46164 — it is the integer portion of the serial — and why typing 1.5 and formatting as a date gives you January 1, 1900 at noon.

For more advanced compositions, Excel's broader function library — including lookup functions, conditional aggregators, and array formulas — interacts beautifully with date fields. You can read more about the full range of available formulas across our other Excel tutorials to extend what you build here.

Formatting is where most date-insertion frustration originates. You type =TODAY(), press Enter, and instead of May 22, 2026 you see 46164. That five-digit number is the serial value, and it indicates the cell's number format is set to General or Number rather than Date. The fix is simple: select the cell, press Ctrl+1 to open Format Cells, choose Date from the category list, and pick the display style that matches your audience. The underlying value never changes — only how Excel paints it on screen does.

Excel offers 22 built-in date formats covering everything from short numeric forms like 5/22/26 to long written forms like Friday, May 22, 2026. You can also build custom formats using format codes: yyyy for four-digit year, mm for two-digit month, mmm for abbreviated month name like May, mmmm for full month name, d for day without leading zero, dd for day with leading zero, and dddd for full weekday name. Combine these freely to match any house style your team or company requires for reports.

Regional differences matter. The United States defaults to month/day/year ordering, while most of Europe and Asia use day/month/year. If you share workbooks internationally, prefer explicit formats like dd-mmm-yyyy that produce 22-May-2026, which is unambiguous across all locales. Avoid 05/22/26 in international correspondence because readers may interpret it as the 5th of an undefined month. Defensive formatting prevents misunderstandings in cross-border finance and operations teams.

To display the date as text inside a sentence, use the TEXT function. ="Report generated on "&TEXT(TODAY(),"mmmm d, yyyy") produces a string like Report generated on May 22, 2026 that you can embed in cover pages, email merges, or header rows. Without TEXT, concatenating a date directly with a string produces the serial number embedded in text, which looks like Report generated on 46164 — almost never what you want. TEXT is your friend whenever date meets prose.

For dashboards, conditional formatting can change a date's color based on how recent it is. Set up rules where dates older than 30 days appear red, dates within 7 days appear yellow, and future dates appear green. Combined with =TODAY() as the reference, these visuals make aging reports legible at a glance. Highlighting overdue receivables this way is a classic AP/AR pattern used by finance teams across virtually every industry vertical you can think of.

Time formatting follows the same principles. hh produces a two-digit hour in 24-hour mode, h produces single-digit hour, mm is minutes (not months when paired with hh), ss is seconds, and AM/PM at the end of the format switches to 12-hour display. Be aware that mm is contextually interpreted — Excel decides whether it means month or minute based on neighboring tokens. When in doubt, type out the format and preview it in the Format Cells dialog before committing.

One final formatting tip: a date copied from a web page or other application sometimes arrives as text rather than a real date value. You can detect this because the cell aligns left instead of right, and TODAY-based arithmetic returns #VALUE! errors. To convert, use DATEVALUE or paste with the Text-to-Columns wizard set to detect dates. Once converted, all the formatting and arithmetic tricks above start working normally again.

Troubleshooting date errors in Excel is its own small art form, and most problems fall into three buckets: the value displays as a number, the value displays as text aligned left, or arithmetic produces unexpected results. The first bucket — a date showing as 46164 — is purely cosmetic and fixed by applying a date format. The second is more insidious because the cell looks like a date but cannot be added, subtracted, or compared. The third often indicates a hidden time component or a locale mismatch between the file's regional settings and your machine's.

If TODAY() returns the wrong date entirely, check your computer's system clock first. Excel reads the operating system date directly, so a misconfigured clock or wrong time zone will propagate into every TODAY-based formula. This is more common than people expect, especially on machines that have traveled across time zones or whose automatic time-sync service has been disabled. A two-minute check of Windows or macOS date settings often resolves problems that look like Excel bugs but are actually environmental.

The dreaded #NAME? error after typing =TODAY() usually means a typo — for instance =TODAY without the parentheses, or =TODY() with a missing letter. Excel needs the exact spelling plus the empty parentheses to recognize the function. Similarly, #VALUE! after subtracting two dates often means one or both cells contain text masquerading as a date. Convert with DATEVALUE or re-enter the cell manually to clear the type mismatch and restore proper arithmetic behavior across the formula chain.

Power users sometimes need today's date in array formulas, conditional sums, and lookup tables. SUMIFS with criteria like ">="&TODAY()-30 lets you sum any column where the date is within the last 30 days. COUNTIFS works the same way for record counts. These patterns turn TODAY into a moving window that adjusts every day with no manual intervention, and they form the backbone of rolling KPI dashboards across sales, support, finance, and operations teams.

VBA users can write Date and Now into cells directly: Range("A1").Value = Date inserts today's date as a static value via macro. This is useful for templates that automatically stamp themselves on open. Power Query users can add a column with DateTime.LocalNow() or Date.From(DateTime.LocalNow()) to produce a refresh-time stamp that updates only when the query refreshes — a nice middle ground between fully volatile and fully static, ideal for ETL pipelines.

If you regularly work with imported text files or CSV exports, dates often arrive as strings in formats Excel cannot auto-detect. The Text-to-Columns wizard with the Date option selected can convert a column of strings to real dates in seconds, including format specifications like MDY or DMY to handle ambiguous values. Once converted, you can subtract TODAY() to compute age, sort chronologically, and apply conditional formatting like any other native date column. Mastering this conversion saves hours over the course of a typical analyst's week.

For more on combining date logic with imports and broader data cleanup, browse our other Excel tutorials covering import workflows, formula references, and data validation strategies that pair beautifully with the techniques you've learned here.

Putting it all together, the practical workflow for most analysts looks like this: use Ctrl+; for any date that represents a real-world event being recorded, use =TODAY() for any header field or aging calculation that should track the current calendar day, and use =NOW() when both date and time precision matter. This mental model resolves about ninety percent of the questions people ask about dates in Excel and produces files that behave predictably for years afterward.

Beyond the basics, consider building a personal Date Cheat Sheet tab inside your most-used templates. List the common patterns — =TODAY(), =TODAY()-A2 for age in days, =TEXT(TODAY(),"mmmm d, yyyy") for formatted text, =EOMONTH(TODAY(),0) for the last day of this month, =DATE(YEAR(TODAY()),12,31) for year-end. Copy-paste from this tab into new sheets as needed. Over months, this habit shaves hours off repeated formula recall and reduces typos that lead to silent calculation errors.

When sharing files across teams, document any volatile date logic in a clearly labeled notes section. A single sentence — Note: Header date in cell B1 uses TODAY() and refreshes daily — prevents downstream confusion when a colleague compares two versions of the report taken at different times. The discipline of self-documenting spreadsheets pays back enormous dividends in audits, hand-offs, and onboarding new analysts who inherit your work.

For long-term projects, build a small archive sheet that captures snapshots of key metrics with their corresponding static dates. Each Monday morning, run a quick macro or manual paste-values routine that copies live TODAY-based metrics into the archive as static rows. Over time you accumulate a historical log that supports trend analysis and looks back without depending on volatile recalculation. This pattern transforms a single-day dashboard into a longitudinal record almost for free.

If you work with international teams, standardize on the ISO date format yyyy-mm-dd whenever possible. This produces 2026-05-22, which sorts correctly as text, parses unambiguously in every locale, and is the official format used in scientific publishing, software logs, and data interchange standards. Using ISO format in raw data and then formatting visually for display gives you the best of both worlds — universal compatibility and locale-appropriate presentation for human readers.

Finally, treat date functions as a gateway drug into the broader world of Excel automation. Once you internalize TODAY, NOW, and the formatting toolkit, you naturally start exploring DATEDIF for age computations, NETWORKDAYS for business-day counting, EDATE for monthly offsets, EOMONTH for billing cycles, and WEEKNUM for ISO week numbering. Each of these functions builds on the same serial-number foundation you learned today, and together they form one of the most-used corners of the entire Excel function library.

The single best way to cement these skills is hands-on practice with realistic problems. Pull up an old workbook, try replacing a manually typed date header with =TODAY(), build a Days Outstanding column with =TODAY()-IssueDate, and format the results properly. Within an hour you'll have absorbed more than any tutorial alone could teach, and you'll be ready to apply these patterns to whatever spreadsheets land on your desk next.