To show the current date and time in Excel, enter =NOW() in a cell; to show just the current date, enter =TODAY(). Both are formulas that update when Excel recalculates, so they are not permanent timestamps.
What Excel’s NOW function returns
In Microsoft Excel for Microsoft 365 on Windows, NOW returns the date and time according to the computer’s system clock. It takes no arguments: the parentheses stay empty. Excel stores the result as a number, with the whole-number portion representing the date and the decimal portion representing the time. For example, a value around 0.5 represents noon, because it is halfway through a 24-hour day.
In a blank worksheet, enter the formula in A1 to see the current date and time: =NOW(). The displayed result depends on the clock and regional settings of the computer or Excel environment, and on when the workbook recalculates. A result might appear as a date and time, just a date, or a number until the cell is formatted appropriately.
NOW does not continuously count forward like a clock on a screen. It supplies a new value when Excel recalculates the formula. That distinction matters when a workbook is used to record when an event happened: a NOW formula is useful for a live, changing value, but it is not a reliable permanent record of the original entry time.
How to enter and format the current date and time
Select a cell, type the formula, and press Enter. If the result displays as a decimal such as 46328.625, the formula can still be correct; the cell is showing Excel’s underlying serial value rather than a readable date and time. Apply a date-and-time number format to make it legible.
- Select the cell or cells containing NOW.
- On Windows, press Ctrl+1 to open Format Cells. On Mac, use Command+1.
- On the Number tab, choose Date or Custom, then select or enter a format that includes both date and time, such as
m/d/yyyy h:mm AM/PM. - Choose OK. Widen the column if the result appears as hash marks.
Formatting changes how the value looks, not the value itself. If you choose a date-only format, the time portion remains stored in the cell but is hidden. This can be important in calculations: two cells that look like the same date may contain different times and therefore may not compare as equal. For a 24-hour display, use a format such as yyyy-mm-dd hh:mm; for a 12-hour display, include AM/PM.
Excel’s format choices and default date order can reflect regional settings. A date shown as 4/5/2026 could mean April 5 or May 4 depending on the chosen convention. A format such as yyyy-mm-dd can make the order clearer when sharing a workbook, though recipients’ software and settings can still affect presentation.
NOW versus TODAY
Use NOW when both the date and time matter. Use TODAY when the date matters and the time should be omitted. In an otherwise empty worksheet, enter this in A1 to return the current date: =TODAY(). If the sheet recalculates on November 2, 2026, the displayed date is November 2, 2026, subject to the cell’s number format.
TODAY is also dynamic. It does not save the date on which a row was first created. For example, a due-date calculation based on TODAY will move forward as days pass; that is often exactly what a countdown or overdue report needs, but it is unsuitable for preserving a historical entry date. NOW includes a time fraction as well, so using it in a date comparison can produce unexpected results if the comparison expects midnight.
Choose the function based on the question the worksheet needs to answer:
- NOW: What date and time does Excel’s clock report at recalculation?
- TODAY: What date does Excel’s clock report at recalculation?
- Static entry: What date or time should remain as originally recorded?
When and why the result updates
NOW and TODAY are volatile functions. Excel recalculates them when calculation occurs, which can include opening or recalculating a workbook and editing cells in a workbook set to automatic calculation. They may therefore change even when the formula itself has not been edited. In Microsoft 365 for Windows, check the setting at Formulas > Calculation Options; Automatic is the usual choice. Excel for Mac has the corresponding calculation options on the Formulas tab. Excel for the web recalculates formulas too, but the timing can depend on workbook activity and the web environment.
To request a recalculation on Windows, press F9 for open workbooks or Shift+F9 for the active worksheet. On Mac, the corresponding recalculation shortcuts can differ by keyboard and Excel version; use the Formulas tab’s calculation commands if a shortcut is unavailable. These actions can update every volatile formula affected by recalculation, not just the selected NOW cell.
NOW is not designed as a second-by-second timer. If the workbook is idle, its displayed value may not visibly advance every second. Recalculation settings and activity affect when the new value appears. A workbook set to Manual calculation may continue showing an older result until a recalculation is triggered. This can make a formula look broken when it is actually waiting for Excel to recalculate.
How to enter a date or time that will not change
For a permanent entry, use a keyboard shortcut rather than NOW or TODAY. In Excel for Windows, select a cell and press Ctrl+; (semicolon) to insert the current date. Press Ctrl+Shift+; to insert the current time. To enter both in the same cell, insert the date, type a space, then insert the time. These shortcuts enter values, not dynamic formulas, so recalculation does not change them.
In Excel for Mac, Control+; inserts the date and Command+; inserts the time in commonly used Mac Excel shortcuts. Keyboard layouts and versions can affect shortcut behavior, so check Excel’s keyboard-shortcut help if a key combination is intercepted by macOS. On the web, shortcuts may also be affected by the browser. A manually typed date is another option, but confirm the cell’s date interpretation to avoid ambiguous entries.
For an existing NOW formula that must become a fixed value, copy the cell and use Paste Special > Values. This replaces the formula with its current displayed value. Keep in mind that pasting values into the wrong range can overwrite formulas, so check the selection first. A fixed timestamp records a value, but it does not by itself establish who entered it or whether it is an audit-quality record.
Excel date serials, precision, and date systems
Excel dates are stored as serial numbers so they can be sorted and used in arithmetic. The integer part counts days within Excel’s date system, and the fractional part represents a portion of a day. As a result, a timestamp can be sorted chronologically and used in elapsed-time calculations. Subtracting an earlier date-time from a later one gives a number of days, including fractions of days; multiplying that difference by 24 converts it to hours.
Most modern Windows workbooks use the 1900 date system. Some workbooks, particularly older Mac workbooks, may use the 1904 date system. The systems use different starting points, so the same serial number can display as dates 1,462 days apart. Excel can adjust dates when copying between workbooks with different systems, but copied raw values or exchanged data can still cause confusion. If dates suddenly shift by several years after a transfer, check the workbook’s date system in its advanced options.
Excel also preserves a historical compatibility quirk in its 1900 date system: it treats 1900 as if it had a February 29, although that year was not a leap year in the Gregorian calendar. This mainly matters in calculations or imported datasets involving very old dates, rather than ordinary current-date use. For everyday work, the practical point is that Excel dates are numeric values, not merely text labels.
Common problems and fixes
- A number appears instead of a date: Apply a date-and-time format with Ctrl+1 on Windows or Command+1 on Mac. The number is often the valid serial value.
- Only the date appears: Change the number format to one that includes hours and minutes. The time may be present but hidden.
- The result does not change: Check Formulas > Calculation Options and recalculate with F9 on Windows. Manual calculation can leave an older result visible.
- A formula is displayed literally: The cell may be formatted as Text or the entry may begin with an apostrophe. Change the format to General, then re-enter the formula.
- The displayed time is unexpected: NOW uses the system clock available to Excel; it does not convert automatically to a chosen time zone. Check the computer’s clock and time-zone settings.
- A date looks different on another computer: Compare the cell’s number format, regional settings, and workbook date system before assuming the stored value changed.
For formulas that need to compare only calendar dates, a hidden time fraction can be the culprit. Formatting a NOW value to show only the date does not remove its time. If the goal is a date-only value that updates, TODAY is the simpler choice. If data comes from a timestamped source, inspect the underlying value and decide whether the time should be retained rather than relying on appearance alone.
Choosing the right method for a worksheet
NOW is useful for dashboards that show the last recalculation time, elapsed-time calculations, or a worksheet that needs a live reference to the present. TODAY is usually better for date-based status reports, such as checking whether a target date has passed. Static shortcuts suit logs, forms, and records where the date or time of entry should stay unchanged.
Think about what “current” means in a shared workbook. NOW reflects the clock available to the Excel session doing the calculation; it is not a centrally synchronized time-zone service. In a team working across regions, agree on a time-zone convention and label it clearly. For a formal audit trail, use an approved system or process that records identity and change history rather than treating a volatile spreadsheet formula as proof of when an event occurred.
Frequently Asked Questions
Does Excel NOW update every second?
No. NOW updates when Excel recalculates the formula, not as a guaranteed continuously ticking clock. Workbook activity and calculation settings influence when the new value appears.
How do I show only the date from NOW?
Apply a date-only number format, but remember that the underlying value still contains the time. If you want a dynamic date without a time component, use TODAY instead.
Why does Excel show a decimal after I enter NOW?
Excel stores dates and times as serial numbers. Apply a date-and-time format to display the value in a familiar form; the decimal is not necessarily an error.
Can I make NOW stay fixed?
Use a date or time insertion shortcut for a fixed entry, or copy a NOW cell and paste its value. A formula left as NOW will change when recalculated.
Does NOW use UTC or my local time?
NOW uses the date and time available from the computer or Excel environment, generally reflecting its system clock settings. It does not provide a built-in time-zone conversion or guarantee a UTC timestamp.
Related
- Excel Not Highlighting Cells When Selected? Fixes
- Excel Not Equal Sign: How to Use the <> Operator
- Excel Not Equal: The <> Operator Explained
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Workbook Not Showing Sheet Tabs? Fixes That WorkIf an Excel workbook is not showing sheet tabs, first check File > Options > Advanced and, under…
- How to Add a Comment to a Header in Microsoft WordTo try adding a comment directly to header text in Word, double-click the header, select the words, then…
- Microsoft Excel: How to Turn Off Flash FillTo turn off automatic Flash Fill in Microsoft Excel for Microsoft 365 on Windows, go to File >…
- Name Badge Template in Word: Create One Step by StepCreate a reusable name badge template in Word by setting up a page and sizing a table to…
- Excel Remove Duplicates: Keep One Copy of Each RowYes. In Excel for Microsoft 365 on Windows, select your data and choose Data > Remove Duplicates; Excel…
- Remove Duplicates in Excel by Entire Row: A Safe GuideTo remove duplicate records in Excel, select the full data range, choose Data > Remove Duplicates, and check…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.