YEAR - The function returns the year corresponding to a date in Excel

The following article introduces you to the YEAR function - one of the functions in the date and time group function is very popular in Excel.

YEAR - The function returns the year corresponding to a date in Excel Picture 1

Description: The function returns the year value corresponding to a date in Excel. The year value is an integer between 1900 and 9999.

Syntax: YEAR (serial_number).

Inside:

- serial_number: Date to search for the year value, is a required parameter.

Attention:

- Excel stores the date as a serial number to facilitate the calculation process.

- The value returned in the YEAR function will be a Gregorian value regardless of the format.

For example:

Calculate the corresponding annual value of the following specific dates:

YEAR - The function returns the year corresponding to a date in Excel Picture 2

- In the cell to calculate enter the formula: = YEAR (F7)

YEAR - The function returns the year corresponding to a date in Excel Picture 3

- Press Enter -> the corresponding year is:

YEAR - The function returns the year corresponding to a date in Excel Picture 4

- Similarly copying the formula for the remaining values results:

YEAR - The function returns the year corresponding to a date in Excel Picture 5

- In case of incorrect input value serial_number -> function returns error value #VALUE!

YEAR - The function returns the year corresponding to a date in Excel Picture 6

Above are instructions and some specific examples when using the YEAR () function in Excel.

Good luck!

Lesley Montoya

Update 19 May 2020

You should read it

May be interested

The WORKDAY function - The function returns a date before or after the start date of a number of working days in Excel
workday - the function returns a date before or after the start date of a specified number of working days. weekends and public holidays do not count toward business days. syntax: workday (start_date, days, [holidays])
How to separate the date, month, and year columns into 3 different columns in Excel
to separate the date, month and year in excel into separate values, we can do it with simple functions on excel.
COUPPCD - The function returns the previous coupon date before the settlement date in Excel
in the previous article introduced to you the function returns the next coupon date after the settlement date. the following article introduces you to the couppcd function - the function returns the previous coupon date before the settlement date.
Excel date function - Usage and examples
the date counting function in excel is one of the most effective functions of this software. because excel usually works in the field of statistics and calculations, it is extremely necessary to record dates. to help you understand this function, let's come to the following article of tipsmake.
How to use the NORMDIST function in Excel - Function that returns the distribution in Excel
the normdist function returns a distribution with a specified mean and standard deviation. the normdist function has applications in statistics, including hypothesis testing.
DAYS function, how to use the function to calculate the number of days between two time points in Excel
the days function in excel returns the results between two different timelines.
SQL Server YEAR function
sql server's year function returns a 4-digit integer that is the year value in the timestamp passed.
WEEKNUM function - The function returns the week number of the year in Excel
weeknum function - the function returns the ordinal number of the week of the year of the specified day in that week. there are 2 systems used in the function to determine the ordinal number of the week: - system 1: week with january 1 is the first week of the year and numbered as 1. - system 2:
CHISQ.TEST function - The function returns the independence test in Excel
chisq.test function: the function returns the independence test. the function returns the value from the distribution (({chi ^ 2})) when squared for statistics and the appropriate degrees of freedom. support function from excel 2010 version. syntax: chisq.test (actual_range, expected_range)
How to use the IF function in Excel
the if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value

YEAR - The function returns the year corresponding to a date in Excel

You should read it

May be interested

Office information