How to use Excel YEAR function
Introduction YEAR function in Excel is a type of DATE/TIME function. It used to find YEAR of a specified date. It can be used to supply YEAR into a cell or used with functions like DATE function as a feeder. Syntax =YEAR( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form of text are entered then there is a possibility of getting an error. Keynotes In General…