If a date is entered into A2, eg 10/17/2007, then in A3 type =YEAR(A2)
However, the date in A2 must be entered in DATE format, ie use =DATE(2007,10,17)
This will display 2007 in A3.
Awkward but can be used. I don't know if others have easier solutions.
I hope that helps
I haven't been able to find a way to display the year in Excel. (Its office 2003)
I want it to display just the year, not any other thing (such as the month or day)
Any help would be appreciated