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?