DEFINITION: Year Function Returns The Year From A Valid Date In A Numeric Value. You Can Use The Year Function To Extract A Year From A Valid Date Into A Particular Cell Either By A Reference Cell Where A Valid Date Is Stored Or By Inputting The Date In Itself. Example Year(“26-12-2020”) Return 2020. Or Year(“12-26-2020”) Return 2020. Enter The Date According To Your Pc Settings.