ExcelBanter - YEAR function issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - YEAR function issue (https://www.excelbanter.com/excel-worksheet-functions/140225-year-function-issue.html)

Barb Reinhardt

YEAR function issue

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

Barb Reinhardt

YEAR function issue

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

All times are GMT +1. The time now is 07:09 AM.