OOOPS! time for new reading glasses!
From Excel's Help: If this function is not available, and returns the #NAME?
error, install and load the Analysis ToolPak add-in.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Bernard Liengme" wrote in message
...
XPVN is not a built-in Excel function. The sender of the file might have
this in a PERSONAL.XLS workbook.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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