If cell A1 contains date like ‘2001-12-25’ then what will be the formula to display only year .
Answers
Answered by
0
select the blank cell adjacent to A1 cell and Type the formula YEAR(A1) in to the formula bar and then press enter key to display result.
Similar questions