Thanks Niek - its working now!
--
Warren B


"Niek Otten" wrote:

From Excel HELP:

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in

--
Kind regards,

Niek Otten

"Warren" wrote in message
...
I am using an XPNV formula, but excel wont recognise the date. It returns a
#name? error. I received the file from someone else, so it may be my
version
of excel.

Can anyone suggest how to sort out the error?
--
Warren B