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

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

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

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

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