(Found it)...The format of the cell where the formula is (in this case A2),
needs to be something other than a date (i.e. general or number).

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