Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

YEAR() returns the year

Input the formula: =YEAR("7/5/2008"). Press Enter to get the result.