Question

Function to extract year from date is

Answer 1

Year function... In excel

Answer 2

Answer:

The correct answer to this question is Type =YEAR(CELL), substituting CELL with a cell reference, to get the year from a cell that contains a date.

Explanation:

Given - Function to extract the year

To Find - Function to extract the year from date is.

The year part of a date is returned as a 4-digit number by the Excel YEAR function. A year value can be extracted from a date and entered into a cell using the YEAR function, or it can be extracted and sent to another formula, such as the DATE function. date: A legitimate Excel date.

Type =YEAR(CELL), substituting CELL with a cell reference, to get the year from a cell that contains a date. For instance, the formula =YEAR(A2) will extract the year from the date value in cell A2.

#SPJ2