98.1 % recommend us More live stats... RSS feeds What's this? All hints and tips:

Hints and tips home » Excel hints and tips » Separate the year from a date

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

Added by Pete on 12th March 2007

More Excel hints and tips, like:

• Display pictures on Chart Data Point
• Finding your worksheets quickly
• Manually wrapping text