December 31, 2017

Use Excel’s YEAR function to extract the year from a date

Happy new year! This is a good time to show Excel’s YEAR function. It extracts the current year from a date. It works whether you entered the date manually, if the date is the result of the =TODAY() or =NOW() functions, or if the date is a serial number, and it works regardless of formatting.

The syntax is:
=YEAR(date)

For example, if the value of A2 is 12/31/2017, the result of =YEAR(A2) is 2017.

To get up to speed quickly on other functions, check out my course, “Excel 2016 Formulas & Functions in 90 Minutes” at www.udemy.com/excel90min

Categories

Share:

Related Posts

Between the Sheets — Excel podcast episode 31: Excel’s secret DATEDIF function

A quick and simple way of finding the number of days, months or years between two dates is Excel’s secret DATEDIF function. When you type it in a worksheet, there’s no popup syntax help to indicate the function exists.

Between the Sheets — Excel podcast episode 29: Using the GoogleFinance function in Google Sheets

In partnership with Experts Exchange. The GoogleFinance function uses Google’s engine to insert financial data in your worksheet, like stock prices, mutual funds, and currency

Between the Sheets — Excel podcast episode 28: Linking and Embedding Excel into Powerpoint

In partnership with Experts Exchange. You can take an Excel sheet and place it on a PowerPoint slide with a link to the source or

Between the Sheets — Excel podcast episode 27: Dynamic ranges and print areas with the Offset function.

In partnership with Experts Exchange. Excel’s Offset function, available in the last couple of versions for Windows and Mac, lets you create ranges that change

Between the Sheets — Excel podcast episode 26: Dynamically collecting data with the TAKE and DROP functions.

In partnership with Experts Exchange. Among the new functions currently in beta and soon to be released in the 365 editions of Excel are TAKE