Excel Current Year: How to Get It with NOW and TODAY

How-to basics · Updated November 18, 2026

As of 2026, the current calendar year is 2026. In Microsoft Excel for Microsoft 365 on Windows, enter =YEAR(TODAY()) in any empty cell to display the current year; it updates when Excel recalculates the workbook. If you specifically need the year from Excel’s current date-and-time value, use =YEAR(NOW()).

How Excel Gets the Current Year

Excel stores dates as numbers and uses date functions to interpret those values. The TODAY function returns the current date according to the computer’s system clock, while NOW returns the current date and time. YEAR takes a date value and returns its year as a number. Combining these functions gives a simple way to show the year without typing it manually.

With no source cells needed, enter =YEAR(TODAY()) in a blank cell such as A1. When the computer date is in 2026, the result is 2026. The result is a number, not a date formatted to look like a year, so it can also be used in calculations, comparisons, or chart labels.

With no source cells needed, enter =YEAR(NOW()) in a blank cell to get the year from the current date and time. It also returns 2026 when the computer’s current year is 2026. For an ordinary current-year label, TODAY is usually simpler because the time component returned by NOW is not needed.

TODAY Versus NOW

TODAY and NOW are both volatile functions: Excel may recalculate them when the workbook recalculates, rather than only when a referenced cell changes. TODAY returns a date without a visible time component. NOW returns a date and a time, although the cell’s number format determines what you actually see. Wrapping either function in YEAR extracts only the year.

For example, a cell containing NOW may display a date and time, only a date, or a number, depending on its formatting. That display does not change what the underlying value contains. YEAR can read the date portion and return its year even when the time is hidden. Use NOW when another part of your calculation needs the current time as well; use TODAY for a year-only result or date-based calculation.

Neither function continuously counts time on the screen. Their values refresh when Excel recalculates, when the workbook opens, or when another event triggers calculation. If the displayed year seems stale, calculation settings or a computer clock set to an incorrect date may be the cause.

Enter the Formula and Check the Result

To add a live current-year result in Excel for Microsoft 365 on Windows:

  1. Select an empty cell where you want the year to appear.
  2. Type =YEAR(TODAY()) and press Enter.
  3. Check that the result matches the year shown by your computer’s calendar.
  4. If the result is not current, verify the computer date and Excel’s calculation setting.

There is no special number format required. If the cell displays a date or an unexpected number, select the cell and choose Home > Number Format > General. You can also choose Number; because the result is a year integer, it should appear as 2026 rather than as a full date. Formatting affects how a value appears, not the calculation itself.

In Excel for Mac, the same formula works. The interface for calculation preferences differs from Windows, and menu labels may vary slightly by release. Excel for the web also supports the functions; it uses the workbook’s calculation behavior and the date settings available in the browser environment.

Make Sure the Formula Updates

Excel normally uses automatic calculation. In the Windows desktop app, check Formulas > Calculation Options > Automatic. If the workbook is set to Manual, formulas may retain old results until you trigger calculation. Pressing F9 recalculates open workbooks in Excel for Windows. After switching a workbook back to Automatic, check whether the year updates as expected.

A date can also be wrong because the device clock is wrong. Excel gets the current date from the operating system, not from a separate online calendar service. If TODAY gives 2025 while the real calendar year is 2026, first check the system date, time, and time zone. A workbook opened on another computer can show a different current date if that computer’s clock or time zone differs, especially near midnight or around New Year.

Because TODAY and NOW recalculate, a workbook that uses them can change its results from one day to the next. That is useful for dashboards and aging reports, but it can be undesirable in a record that must preserve the date it was created. Decide whether the year should be live or fixed before building other formulas around it.

Use a Fixed Year Instead of a Live One

If a report should keep the year that applied when it was prepared, do not leave a TODAY-based formula in the final value cell. Enter the year as a number, or create the formula and then replace its result with a value. In Windows Excel, copy the cell and choose Home > Paste > Paste Values. This keeps the displayed result while removing its live calculation.

A fixed year is appropriate for a dated invoice, an archived annual report, or a historical entry. A live year is more appropriate for a reusable dashboard that should always refer to the present year. If you want to record an exact date rather than just the year, enter a fixed date or paste a date value; otherwise, a formula based on TODAY will move forward as time passes.

For a workbook that spans multiple years, avoid replacing every historical date with the current year. Keep each record’s actual date in its own cell and derive its year from that date. That preserves the distinction between, for example, a sale made in 2024 and a sale made in 2026.

Get the Year from a Date in a Cell

To report the year for a particular date, use YEAR with the cell containing that date, rather than TODAY. With a valid Excel date in A2, enter =YEAR(A2) in B2. If A2 contains July 18, 2024 as a real Excel date, B2 returns 2024. This is useful for grouping transactions, filtering records by year, or adding a year column to a list.

A common source of confusion is a date that only looks like a date. Imported data may store dates as text, and changing the number format will not necessarily convert text into a usable Excel date. If YEAR returns an error or gives an unexpected result, inspect the source cell and check how the data was imported. Regional date order matters too: a text value such as 03/04/2026 can be interpreted differently depending on whether the source uses month/day/year or day/month/year.

For a valid date, the year can also be displayed by changing its number format without using YEAR. Select the date cell, open Format Cells, and choose a date format that shows the year. This preserves the underlying full date. Use YEAR when you need the year as a separate numeric result; use formatting when you only want the original date to appear differently.

Find the Start of the Current Year

Sometimes a report needs the first day of the current year, not just the year number. With no source cells needed, enter =DATE(YEAR(TODAY()),1,1) in an empty cell. In 2026, the result is January 1, 2026, stored as an Excel date. Format the result as a date if it appears as a serial number.

This is useful as a boundary for a year-to-date calculation, but it does not itself filter or add data. If you use a start date in a report, make sure the dates being compared are real Excel dates and that the comparison includes the intended first day. For an annual summary that should stay fixed after the year ends, record the relevant start date as a value rather than leaving it tied to TODAY.

Common Problems and Misconceptions

  • The formula shows a serial number: The result may be a date displayed with General formatting, or the source cell may be a date. Set the number format to General for a year number, or a suitable date format for a date.
  • The answer does not change at midnight: Volatile formulas update during recalculation; they are not a continuously running clock. Recalculate the workbook or check whether calculation is set to Manual.
  • The workbook uses last year: Check calculation mode and the computer’s date. Also consider whether a fixed value was pasted over the formula.
  • Changing formatting does not fix YEAR: Number formats change display, not the underlying type of a text value. Convert or re-import text dates as actual dates before extracting their year.

Another misconception is that TODAY and NOW use a date supplied by Microsoft or update identically in every location. They rely on the system date and Excel’s recalculation, so different devices can briefly disagree if their clocks or time zones differ. A formula is therefore convenient for ordinary work, but it is not a substitute for checking the source of an official timestamp.

Frequently Asked Questions

What year is it in Excel right now? As of 2026, the calendar year is 2026. To show the computer’s current year dynamically in Excel, enter =YEAR(TODAY()) in an empty cell.

What is the Excel formula for the current year? Use =YEAR(TODAY()). It returns the year from the current date and updates when Excel recalculates. =YEAR(NOW()) also works if you want the year from NOW’s date-and-time value.

Does TODAY update automatically in Excel? It updates when Excel recalculates the workbook, but not as a continuously ticking display. Automatic calculation is the usual setting; Manual calculation can leave the result unchanged until recalculation.

How do I get the year from a date in another cell? If the actual Excel date is in A2, enter =YEAR(A2) in another cell. The result is a number such as 2024. If the source is text rather than a real date, convert it before relying on the result.

How can I keep the current year from changing later? Copy the formula result and use Home > Paste > Paste Values, or type the year as a fixed value. A live TODAY or NOW formula is designed to update, so it is not suitable when the recorded year must remain unchanged.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.