YEAR - The function for the value is the year of a numeric expression in Excel

The following article details how to use the YEAR function, the function for the year value of a numeric expression.

Description: The function returns the year of any date value, the year value is an integer between 1900 and 9999.

Syntax : YEAR (serial_number) .

Inside:

serial_number : is the date value in the year to search, is a required parameter.

For example:

Calculate year values in different date formats in the following table:

YEAR - The function for the value is the year of a numeric expression in Excel Picture 1

In the cell to calculate enter the formula: = YEAR (C7) .

YEAR - The function for the value is the year of a numeric expression in Excel Picture 2

Press Enter -> the year value in the date value is:

YEAR - The function for the value is the year of a numeric expression in Excel Picture 3

Similarly copy the formula for the remaining cells to get results:

YEAR - The function for the value is the year of a numeric expression in Excel Picture 4

So with many different date formats but the HOUR function gives accurate results.

Above is how to use as well as some common cases using the HOUR function .

Good luck!

Kareem Winters

Update 19 May 2020

You should read it

AVEDEV function - The function returns the average absolute deviation of data points from their midpoint in Excel
avedev function: the function returns the average absolute deviation between a given data point and the average value of the population. the function is a measure of the variability of a dataset
DATEVALUE function - The function converts dates into numbers in Excel
datevalue function: the function converts text dates into serial numbers that excel understands
The DAY function - The function returns the day of the day, month and year in Excel
the day function: the function takes a date value from a date value. the return value is an integer between 1 and 31.
MINUTE function - The function converts a serial number into a minute in Excel
minute function: the function returns the minute value of a time value. minutes are returned as integers between 1 and 59.
MONTH function - The function converts a serial number into a month in Excel
month function: function performs month value separation in a specific date time month. the return month value is an integer between 1 and 12.
NOW function - The function returns the current date and time in Excel
now function: the function returns the current date and time. the now function is useful when you want to display the current date and time. the now function does not update continuously, it only updates when you have editing operations on the data area containing it.