Getting the today date in Excel is one of the most common things spreadsheet users need, and the TODAY function makes it effortless. By typing the simple formula =TODAY() into any cell, Excel instantly returns the current calendar date based on your computer's system clock. This single function powers payroll timesheets, invoice aging reports, project countdowns, and dashboards that must always show the present day. Because it updates automatically every time the workbook recalculates, you never have to retype dates manually or worry about stale information.
The beauty of TODAY() is that it requires no arguments at all. You simply open the parentheses, close them immediately, and press Enter. Excel handles everything else internally, reading the date from Windows or macOS and converting it into a serial number that it displays in a readable date format. This makes it perfect for beginners learning their first formulas and equally valuable for advanced analysts building large financial models that depend on the current reporting date.
Many people confuse TODAY() with the NOW() function. The difference matters: TODAY() returns only the date with the time set to midnight, while NOW() returns both the date and the exact time of day. If you only care about which calendar day it is, TODAY() keeps your cells clean and avoids unnecessary time stamps. If you need hours and minutes for logging or scheduling, NOW() is the better choice. Both functions are volatile, meaning they recalculate constantly.
This guide walks you through everything about working with today's date in Excel, from inserting the formula and formatting the output to calculating ages, counting days until a deadline, and freezing a date so it never changes. Just as functions like VLOOKUP excel users rely on for lookups, TODAY() is a foundational tool that appears in countless real workbooks across finance, HR, logistics, and education sectors every single working day.
You will also learn the subtle traps that trip up new users, such as why your date sometimes shows as a five-digit number instead of a real date, how regional settings change the display order of month and day, and why a workbook opened tomorrow shows a different result. Understanding these behaviors early saves hours of frustration and helps you build spreadsheets that behave predictably no matter who opens them or when they do so.
By the end, you will be comfortable combining TODAY() with other formulas to create dynamic, self-updating reports. Whether you are tracking invoice due dates, building an attendance sheet, or simply stamping a printout with the current day, mastering this small but mighty function gives you a reliable foundation for nearly every date-based calculation Excel can perform. Let us begin with the core numbers and the exact steps you need.
Click the empty cell where you want today's date to appear. The cell should be formatted as General or Date so Excel can display the result correctly rather than as a raw serial number.
Enter =TODAY() exactly, including the empty parentheses. There are no arguments to add inside them, so leave the brackets closed and immediately press Enter to confirm the entry.
Excel instantly displays the current calendar date. Behind the scenes it stores a serial number, but the cell shows a human-readable date such as 5/26/2026 in US format by default.
Press Ctrl+1 to open Format Cells, choose the Date category, and select your preferred layout. This controls whether you see short dates, long dates, or a custom month-day-year arrangement.
Close and reopen the workbook the next day, or press F9 to force recalculation. The displayed date should advance automatically, confirming the volatile TODAY function is working correctly.
Once you have inserted today's date in Excel, the next skill is shaping how that date looks and using it inside calculations. By default Excel shows the short date format tied to your regional settings, which in the United States means month/day/year. To change this, select the cell, press Ctrl+1, and open the Format Cells dialog. From the Date category you can pick long formats like Tuesday, May 26, 2026, or build a custom format such as dd-mmm-yyyy for cleaner reports and dashboards.
Excel stores every date as a serial number counting the days since January 1, 1900. That means today's date is really a large integer like 46168, and the date you see is just a display mask sitting on top of that number. This design is genius because it lets you perform arithmetic directly. Subtracting one date from another returns the number of days between them, and adding a number to TODAY() pushes the date forward into the future.
A classic example is calculating an invoice due date. If your terms are net 30, you simply write =TODAY()+30 and Excel returns the deadline thirty days from now. To count how many days remain until a fixed event, subtract today from the target date: =A1-TODAY(). The result is a plain number of days, which you can wrap in conditional formatting to highlight overdue items in red. These patterns appear in nearly every business tracking sheet.
Age calculation is another favorite. Combine TODAY() with the DATEDIF function to find a precise age in years: =DATEDIF(B2,TODAY(),"Y") returns completed years between a birthdate in B2 and now. Swap the "Y" for "M" or "D" to get months or days instead. This keeps employee tenure, customer loyalty length, and equipment age perfectly current without anyone editing the sheet, because TODAY() refreshes the moment the file recalculates.
You can also extract parts of today's date using helper functions. YEAR(TODAY()) returns the current year as a number, MONTH(TODAY()) gives the month, and DAY(TODAY()) returns the day of the month. These are useful for filtering records, building dynamic chart titles, or auto-naming monthly report tabs. Pairing them with TEXT() lets you produce strings like "Report for May 2026" that always reflect the present period without manual edits each cycle.
Formatting and arithmetic together unlock dynamic dashboards. Imagine a header cell that reads "Updated: " combined with TODAY() using the ampersand operator and the TEXT function to control the appearance. The formula ="Updated: "&TEXT(TODAY(),"mmmm d, yyyy") produces a clean timestamp line. Just as people search for how to merge cells in Excel to build tidy headers, mastering date formatting gives your reports a polished, professional, always-current finish that impresses managers and clients alike.
Finally, remember that arithmetic with dates assumes both values are real dates, not text that merely looks like a date. If a subtraction returns a strange error or a huge number, the culprit is usually a text-formatted cell. Converting text to genuine date values with DATEVALUE or Excel's data tools fixes the problem and restores correct calculations across every formula that depends on the current day.
The TODAY function returns only the current calendar date with no time component, internally set to midnight. It takes zero arguments, so you always write it as =TODAY() with empty parentheses. It is volatile, meaning it recalculates every time the workbook opens, every time you press F9, and whenever any cell changes that triggers a recalculation across the sheet.
Use TODAY() whenever you only care about which day it is, such as aging invoices, counting days to a deadline, or stamping a printed report with the current date. Because it carries no time, subtractions between two TODAY-based dates return whole numbers of days, keeping your formulas clean and predictable for everyday business reporting and scheduling tasks across departments.
The NOW function returns both the current date and the exact time of day down to the second, read straight from your system clock. Like TODAY, it requires no arguments and is fully volatile, refreshing on every recalculation. The serial number it produces includes a decimal portion that represents the fraction of the day that has elapsed since midnight.
Choose NOW() when timestamps matter, such as logging when a record was entered, tracking shift start times, or building real-time monitoring dashboards. Be aware that because it changes constantly, NOW() can make a sheet feel jumpy. Format the cell with a custom date-and-time mask so users clearly see both components rather than a confusing decimal serial value.
Sometimes you want a date that never changes, such as the day an order was placed or a document was signed. For that, skip the volatile functions entirely and insert a static date using the keyboard shortcut Ctrl+; on Windows or Command+; on Mac. This stamps the current date as a fixed value that will not move tomorrow.
Static dates are essential for audit trails and historical records where accuracy of the original moment must be preserved. If you accidentally used TODAY() and later need to freeze it, copy the cell and use Paste Special, then choose Values to convert the live formula into a permanent date that remains constant no matter when the workbook is reopened later.
If you need a date that stays fixed forever, never use =TODAY(). Press Ctrl+; instead to stamp a static date. Use TODAY() only when you genuinely want the value to refresh every single day the workbook is opened.
Even though TODAY() is simple, several errors trip up users regularly, and knowing them saves real frustration. The most common issue is seeing a five-digit number such as 46168 instead of a readable date. This is not a bug at all. Excel is showing you the underlying serial number because the cell is formatted as General or Number. The fix takes seconds: select the cell, press Ctrl+1, choose the Date category, and pick a format. The number instantly transforms into a proper date.
Another frequent surprise is the date displaying in the wrong order, such as the day appearing before the month. This stems from regional and language settings in Windows or macOS rather than from Excel itself. American users expect month/day/year, while many other regions use day/month/year. If your workbook will be shared internationally, use an unambiguous custom format like dd-mmm-yyyy so that 26-May-2026 reads clearly to everyone regardless of their local settings or assumptions.
A subtle problem appears when TODAY() seems frozen and refuses to update. This usually means automatic calculation has been switched off. Go to the Formulas tab, click Calculation Options, and ensure Automatic is selected rather than Manual. With manual calculation enabled, the date only refreshes when you press F9, which can mislead you into thinking the function is broken when it is actually waiting for a recalculation trigger that never arrives.
Sometimes users wrap arguments inside the parentheses, writing something like =TODAY("5/26/2026") and receiving an error. Remember that TODAY() accepts no arguments whatsoever. The parentheses must stay empty. If you want a specific fixed date, use the DATE function instead, such as =DATE(2026,5,26). Mixing these two functions is one of the most common beginner mistakes, and recognizing the distinction immediately resolves the confusing error messages that result.
Date arithmetic can also fail when one of the values is actually text that merely looks like a date. If subtracting two cells returns a #VALUE! error or an unexpectedly enormous number, the culprit is almost always a text-formatted entry imported from another system. Excel cannot subtract text from a real date. Convert the offending cells using DATEVALUE or the Text to Columns wizard, and your formulas will spring back to life with correct day counts.
Finally, beware of trusting a wrong system clock. Because TODAY() reads directly from your computer's date setting, a machine with an incorrect clock will produce an incorrect today's date in every workbook. This is rare on networked office computers that sync automatically, but it can happen on older laptops with dead CMOS batteries. If your date seems impossible, check the operating system clock before assuming the spreadsheet formula itself has somehow malfunctioned.
Learning to diagnose these issues quickly turns TODAY() from a source of mystery into a dependable everyday tool. Most problems reduce to one of three causes: a formatting display mask, a calculation setting, or a text-versus-date type mismatch. Once you internalize that checklist, you can troubleshoot virtually any date oddity in seconds and keep your reports running accurately and automatically for years.
Beyond the basics, TODAY() shines in advanced, real-world spreadsheet projects that professionals build every day. One powerful pattern is the dynamic aging report used in accounts receivable. By subtracting an invoice date from TODAY() and feeding the result into nested IF logic or the IFS function, you can automatically bucket invoices into categories like current, 1-30 days overdue, 31-60 days, and beyond. The entire report reclassifies itself each morning, giving finance teams an always-accurate snapshot without a single manual edit anywhere in the workbook.
Another popular use is countdown tracking for projects and events. A formula like =A1-TODAY() placed next to each milestone shows exactly how many days remain. Wrap it in conditional formatting and milestones turn amber as they approach and red once they slip past due. Project managers love this because the visual urgency updates on its own, prompting action without anyone needing to recalculate dates by hand or remember to refresh the sheet manually.
TODAY() also drives dynamic chart titles and report headers. Using the TEXT function, you can generate a heading such as "Sales Dashboard โ May 26, 2026" that always reflects the current day. Combine this with functions that filter records by the current month, and you have a self-maintaining monthly dashboard. Just as users searching how to create a drop down list in Excel build interactive selectors, date-driven headers add a layer of professional automation to your reports.
In human resources, TODAY() paired with DATEDIF calculates live employee tenure for anniversary tracking and benefits eligibility. A single column can show years of service that increment automatically, flagging staff who reach milestones for recognition or vesting. The same approach tracks equipment warranty windows, subscription renewals, and contract expirations, ensuring nothing important slips through the cracks because the spreadsheet quietly recalculates every deadline relative to the present day.
You can build smart scheduling sheets too. Functions like WORKDAY combined with TODAY() calculate the next business day or a deadline that skips weekends and holidays. For example, =WORKDAY(TODAY(),5) returns the date five working days from now, automatically jumping over Saturdays and Sundays. Logistics, legal, and compliance teams rely on these calculations to honor service-level agreements and statutory deadlines that must be measured in business days rather than calendar days.
Conditional alerts represent another sophisticated application. By comparing a stored date against TODAY() inside an IF formula, you can display warning text such as "Action Required" or "Expired" the instant a threshold is crossed. People who learn how to freeze a row in Excel to keep headers visible often pair that skill with these alert columns, producing dashboards where the top rows stay locked while date-driven status messages update live below them every day.
The common thread across all these examples is automation. TODAY() removes the human chore of updating dates, which is both tedious and error-prone. By anchoring your calculations to a single self-refreshing reference point, you build workbooks that stay accurate indefinitely. Whether you manage finances, projects, people, or inventory, weaving the current date into your formulas transforms static spreadsheets into living tools that always reflect reality the moment they are opened.
To get the most reliable results from today's date in Excel, adopt a few practical habits that seasoned analysts swear by. First, always format your date cells deliberately rather than leaving them as General. A consistent, explicit format prevents the dreaded serial-number display and ensures that everyone who opens your workbook sees the same clear date. Decide on a house style, such as dd-mmm-yyyy, and apply it across every date column for a professional, unambiguous, and internationally readable appearance throughout your reports.
Second, be intentional about whether you need a live or a static date. Before typing =TODAY(), ask yourself whether the value should change tomorrow. For order dates, signatures, and historical logs, press Ctrl+; to lock in a permanent value. For deadlines, aging, and dashboards, embrace the volatility of TODAY(). Making this decision consciously at the moment of entry prevents the subtle data-integrity problems that surface weeks later when records mysteriously shift their dates.
Third, document your date logic with comments or a notes column, especially in shared workbooks. When a formula calculates a due date as TODAY()+45, a brief note explaining the 45-day term helps colleagues understand and trust the number. Clear documentation also makes future maintenance painless, because the next person editing the sheet immediately grasps why a date behaves the way it does rather than guessing or accidentally breaking the calculation.
Fourth, test your spreadsheet by changing your perspective on time. To confirm that countdowns and alerts behave correctly, temporarily adjust how you think about the target dates, or build a small test area with sample past and future dates. Watching conditional formatting flip from green to red as a deadline passes gives you confidence that the live logic will perform exactly as expected when real deadlines actually arrive in production use.
Fifth, keep performance in mind on very large models. Because TODAY() and NOW() are volatile, they and everything that depends on them recalculate constantly. In a workbook with hundreds of thousands of formulas, excessive volatile functions can introduce noticeable lag. A smart technique is to place a single TODAY() in one master cell and reference that cell elsewhere, reducing the number of volatile calculations Excel must perform on every recalculation cycle.
Sixth, learn the companion date functions that multiply TODAY()'s usefulness. EOMONTH finds the last day of a month relative to today, EDATE shifts a date by whole months, and WEEKDAY identifies the day of the week. Knowing this small toolkit lets you answer almost any business date question. Many learners build this knowledge alongside lookup skills, since combining dates with lookups unlocks sophisticated, automated reporting that genuinely saves hours of manual work every week.
Finally, practice deliberately with realistic scenarios rather than abstract examples. Build a mock invoice tracker, an employee anniversary sheet, or a project countdown and watch them update over several days. Hands-on repetition cements the concepts far better than reading alone. Take the free practice quizzes linked throughout this guide, review any questions you miss, and revisit the formulas until inserting and manipulating today's date in Excel becomes second nature for you.