Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Excel Line Chart
  • Excel Frequency Function Example
  • How To Create Pareto Chart in Excel
  • Move chart to a separate worksheet in Excel

References

  • Excel Advanced Lookup using Index and Match Functions
  • How to get relative column numbers in a range in Excel
  • To count total rows in a range in Excel
  • How to use Excel FORMULATEXT function
  • How to get first column number in range in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation allow weekday only
  • Excel Data validation date in specific year
  • Data validation must not exist in list
  • Excel Data validation specific characters only

YEAR function: Description, Usage, Syntax, Examples and Explanation

by

What is YEAR function in Excel?

YEAR function is one of Date and Time functions in Microsoft Excel that returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.

Syntax of YEAR function

YEAR(serial_number)

The YEAR function syntax has the following arguments:

  • Serial_number: The date of the year you want to find. Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
Worked Example:   How to generate series of dates increment by 1 year from a single start date in Excel

YEAR formula explation

Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900.

Values returned by the YEAR, MONTH and DAY functions will be Gregorian values regardless of the display format for the supplied date value. For example, if the display format of the supplied date is Hijri, the returned values for the YEAR, MONTH and DAY functions will be values associated with the equivalent Gregorian date.

Worked Example:   Excel Date & Time Functions Example

Example of YEAR function

  • Count dates in given year 
  • Sum by month ignore year

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Worked Example:   Get fiscal year from date in Excel

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

Data    
Date
7/5/2008
7/5/2010
Formula Description (Result) Result
=YEAR(A3) Year of the date in cell A3 (2008) 2008
=YEAR(A4) Year of the date in cell A4 (2010) 2010

Post navigation

Previous Post:

YEARFRAC function: Description, Usage, Syntax, Examples and Explanation

Next Post:

WORKDAY function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Complete List of Excel Logical Functions, References and Examples
  • IF, AND, OR and NOT Functions Examples in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Add decimal minutes to time in Excel
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • Create date range from two dates in Excel
  • SECOND function: Description, Usage, Syntax, Examples and Explanation
  • How to get Holiday Date from Year in Excel

Grouping

  • Map text to numbers in Excel
  • How to randomly assign data to groups in Excel
  • Group arbitrary text values in Excel
  • Group times into 3 hour buckets in Excel
  • Map inputs to arbitrary values in Excel

General

  • How to calculate percentage discount in Excel
  • Subtotal by color in Excel
  • Basic numeric sort formula in Excel
  • How to calculate percent change in Excel
  • List sheet names with formula in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning