In Microsoft Excel for Microsoft 365 on Windows, today’s date, November 3, 2026, is serial number 46329 in the standard 1900 date system. Enter =TODAY() in a cell to return today’s date; change that cell’s number format to General to see its underlying number.
Why Excel Has a Date Number
Excel stores dates as numbers so it can calculate with them. In the standard 1900 date system, a whole-number serial represents a calendar day: later dates have larger numbers, and subtracting one date from another gives the number of days between them. The serial is not a special date code that must be decoded by hand; it is the value Excel uses behind the familiar date display.
For example, when a cell contains the date November 3, 2026, Excel can store the value 46329 while displaying it as 11/3/2026, 3-Nov-2026, or another date format. Those displays look different, but they can represent the same underlying value. If the cell is formatted as General or Number, the serial is visible instead of the calendar-style display.
Excel’s date system has historical behavior that matters for very old dates: to remain compatible with the Lotus 1-2-3 spreadsheet program, Excel treats 1900 as if it were a leap year, even though it was not. Excel includes a nonexistent February 29, 1900 in its serial sequence. This compatibility quirk affects dates near the beginning of the system, not the November 2026 result.
How to Show Today’s Serial Number
In any empty cell, such as A1, enter =TODAY(). The function has no arguments and returns the current date according to the date available to Excel. If A1 is formatted as a date, it will look like a date; if it is formatted as General, it will show 46329 on November 3, 2026 in a workbook using the 1900 system.
To change the display in Excel for Microsoft 365 on Windows, select the formula cell, then choose Home > Number Format and select General. The Number Format control is the dropdown in the Number group. You can also select the cell and press Ctrl+1 to open Format Cells, then choose General on the Number tab. On Mac, Command+1 opens Format Cells; the Home tab also has a number-format control. Excel for the web provides number-format choices on the Home tab, though the ribbon layout can differ slightly.
Changing a cell to General changes how its value is displayed, not the value returned by TODAY. To return to a date display, select an appropriate date format from the same number-format control. This distinction is useful: the serial number is the stored value, while the format determines how a person sees it.
What TODAY() Does and When It Changes
TODAY() is a volatile function, meaning Excel recalculates it as the workbook recalculates. It is designed to reflect the current date, so the result is not a permanent record of the day on which the formula was first entered. On November 4, for example, the formula should return the serial for November 4 rather than remain at 46329.
It does not act as a live clock that refreshes every second or necessarily change at the exact moment midnight passes. The value updates when Excel recalculates the workbook. With calculation set to Automatic, that usually happens as workbook values change and when the workbook is opened or recalculated. If calculation is set to Manual, press F9 on Windows to recalculate; on Mac, use the corresponding F9 shortcut, which may require the Fn key depending on keyboard settings. Check Formulas > Calculation Options if dates appear not to update.
TODAY uses the date available to the application and its environment; it does not take a time-zone argument. If a workbook is used by people in different locations, or opened on desktop and web, consider whether “today” should mean the user’s local calendar date or one agreed business date. For a deadline report, that distinction can matter around midnight or across time zones.
1900 and 1904 Date Systems
The result 46329 assumes the workbook uses Excel’s 1900 date system, which is the normal system for modern Windows workbooks. Excel also supports a 1904 date system associated with older Macintosh workbooks. The same calendar date has a serial number 1462 lower in that system, so November 3, 2026 is 44867 there. A difference between two dates within one workbook remains the same number of days, but serials cannot always be compared safely across workbooks using different systems.
On Windows, a workbook’s setting is available under File > Options > Advanced, in the section for calculating the workbook; look for Use 1904 date system. Excel for Mac also supports the 1904 system, with the setting under Excel’s calculation preferences or settings; the exact label or location can vary by release. Before changing this option, consider whether the workbook contains existing dates. Switching systems can shift displayed dates by 1462 days, which can make imported or linked values look wrong.
If a date is off by exactly 1462 days after copying values between workbooks, the two workbooks may use different date systems. Compare the setting in both files before correcting individual cells. Avoid manually adding or subtracting 1462 without first confirming the cause, because that could conceal a different data problem.
Using the Serial Number in Date Calculations
Because dates are numeric, ordinary arithmetic often works as expected. If a cell contains a valid date, adding 1 advances it by one day, and subtracting an earlier date from a later one gives elapsed days. A value such as 46329 is therefore useful in formulas and sorting even though most people prefer to view it as a formatted date.
For example, in any empty cell you can enter =TODAY()+7 to calculate the date seven days from today. On November 3, 2026, the underlying result is 46336, corresponding to November 10, 2026 in the 1900 system. Format the result as a date if you want to see the calendar day instead of the serial. This is a rolling calculation: its result moves forward as TODAY recalculates.
To store a fixed date rather than a formula that changes, enter a date value directly or use the current-date shortcut. In a selected cell, Ctrl+; on Windows inserts the current date as a fixed value; in Excel for Mac, Control+; is the corresponding shortcut on standard keyboard layouts. A fixed entry will not advance tomorrow. That makes it more suitable for a recorded “date received” or “date approved” than TODAY, which is better for a live status or due-date calculation.
Common Reasons the Number Looks Wrong
- The cell shows a date instead of a number: Its date format is controlling the display. Choose General or Number to view the serial.
- The cell shows a number instead of a date: The value may be valid but formatted as General. Apply a date format to display it as a calendar date.
- TODAY does not change: Check whether calculation is set to Manual, then recalculate. Also confirm the computer or environment’s date is correct.
- A date appears off by 1462 days: Check whether source and destination workbooks use different date systems.
- A date behaves like text: Imported text that looks like a date may not be a true Excel date value. Changing its number format alone will not necessarily convert text into a serial.
Regional settings can also affect how dates are entered and displayed. For example, 3/11/2026 can mean March 11 or November 3 depending on the date convention in use. A cell’s visible date format and the workbook’s regional interpretation are separate issues from the serial itself. When exchanging files, unambiguous formats such as 3-Nov-2026 can help readers understand the intended date.
Choosing Between TODAY() and a Fixed Date
Use TODAY when the date should always mean the current day at recalculation time. Common uses include showing how many days remain until a target, flagging records that are overdue, or displaying a report’s current date. Since the result is dynamic, a report can give a different answer tomorrow even if none of its source rows changed.
Use a fixed date when the value is part of a historical record. A date of payment, submission, inspection, or approval should generally remain the date on which that event occurred. If such a cell contains TODAY, it can silently change later and no longer document the event. A manually entered date or the fixed-date shortcut avoids that specific problem.
A useful decision is to ask whether the cell should move with the calendar. If yes, use a formula such as =TODAY(). If no, enter a fixed date. For a report that needs both, keep a fixed event date in one column and calculate its age or status in another. This preserves the original information while still allowing a live calculation.
Frequently Asked Questions
What is today’s date number in Excel?
On November 3, 2026, today’s date is 46329 in Excel’s standard 1900 date system. In a workbook using the 1904 system, it is 44867.
What formula returns today’s date in Excel?
Enter =TODAY() in a cell. It returns the current date as a date value, which Excel may display as a formatted date or as a serial number depending on the cell’s number format.
How do I make Excel show the date serial?
Select the date cell and change its number format to General, using Home > Number Format > General on Windows. The underlying date value will then appear as a number.
Does TODAY() update automatically?
It updates when Excel recalculates the workbook, rather than continuously like a clock. Automatic calculation is the usual setting; with Manual calculation, recalculate the workbook to refresh it.
Why is my Excel date number different?
It may be a different date, a workbook using the 1904 system, or a value that is text rather than a true date. Confirm the date system and cell value before changing the number.
Quick Takeaway
For November 3, 2026, the answer to “today’s date in Excel number?” is 46329 in the standard 1900 system. Use =TODAY() for a date that updates with recalculation, and set its format to General to reveal the serial. Use a fixed date when the value needs to preserve a historical event rather than follow the calendar.
Related
- Sales Order Tracking Excel Template: Setup and Tips
- RSVP List Template Excel: Build and Track Guest Replies
- Room List Template Excel: How to Build and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel IFS in Conditional Formatting: How to Use ItYes. In Excel for Microsoft 365 on Windows, you can use the IFS function in a conditional-formatting formula,…
- Find Month and Year From a Date in Excel with FormulasTo find a month and year from a date in Excel, enter =MONTH(A2) for the month number and…
- INDIRECT Excel Formula for a Different Sheet: ExamplesIf cell A1 contains a worksheet name and you want the value in B2 on that sheet, use…
- Find the Highest Value in Excel with the MAX FunctionTo find the highest number in an Excel range, enter =MAX(B2:B20) in an empty cell, replacing B2:B20 with…
- Power Query Sort: How to Sort and Keep Rows in OrderTo sort data in Power Query in Excel for Microsoft 365 on Windows, open the query, select the…
- Excel Formula for Hours Between Two TimesTo calculate hours between two times in Excel, subtract the start time from the end time and multiply…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.