I guess the date is fine but the cell A2 is been formatted as "yyyy"
for this reason it is giving 1905 instead of 2008.
change to general category ....



On Sep 25, 2:06*pm, dbdewitt
wrote:
As I understand it, the YEAR formula should return the year to which the
formula relates. *I have a date of 4/24/2008 in a cell (let's say it's in
cell B2), when I enter the formula (let's say in cell A2) "=YEAR(B2)", the
result is 1905 where the result should be 2008. *Can someone tell me what I'm
missing?