Found the problem. I had the result cell formatted to YYYY

"Barb Reinhardt" wrote:

I have the following formula

=IF(ISBLANK($O8),NA(),YEAR($O8))

$O8: 12/28/2005 which is interpreted by the formula as 38714

I'm getting 1905 as a result.

Suggestions?

Thanks,
Barb