It would appear that the "date" in H6 might be the result of a Named Range
that does not exist.........perhaps a type-O?

Vaya con Dios,
Chuck, CABGx3





"John Michl" wrote:

I'm having a problem with a function on a colleague's computer. The
following formula...
=YEAR(H6)
works find on my computer but returns a Name Not Found error on her
computer (Excel 2002, SP3). She states that she receives a message
when opening the file asking if she wants to update links. There are
no links in the workbook!

She does have the Analysis ToolPak add-in installed and the formula
=WEEKNUM(H6) works fine.

What's up? Isn't YEAR a standard function?

Thanks for the help.

- John