Date Time Functions MSOfficeExcel 2007 Tutorial

=YEAR("7/5/10"). Press Enter to get the result