Bookmark page
Printable version
Course updates
|
RSS feeds
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:
- Adding up rows or columns without seeing formulas
- Using Excel's MODE function
- Number format shortcut
 |
How To Use The Research Functionality In Excel 2010 Many of you will be familiar with Excel as the basic number cruncher and chart generator. Were you aware however that it can also automatically bring back company information from searching financial sites, translations which can be inserted into cells and complete web searches using Bing? And all this can be done without even leaving Excel. Allow me to explain! » Article: Excel consultancy |
» Forum post: Documenting and Auditing |
How do I hide a comment box??
