YEAR function issue

B

Barb Reinhardt

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
 
Top