YEAR

Command: YEAR

=year(cell reference to a date)

 

Example 1:

09/25/2005 or cell a1

=year(09/25/2005) or =year (a1) --> asking Excel to give you the year from the date

Result in Excel is "2005"

 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)