Hi,

=Year(B2) would return 2008 if B2 contained a correctly formatted 2008
date. If it wasn't correctly formatted then I'd expect it to return either
1900 or 1904 depending on which date system you had set in your options. If
it's returning 1905 then that's odd and suggests B2 has a value in the range
of 1828 - 2192 in it, are you sure that's correct and not a typo?

Mike

"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?