XNPV - cant recognise dates

W

Warren

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?
 
B

Bernard Liengme

XPVN is not a built-in Excel function. The sender of the file might have
this in a PERSONAL.XLS workbook.
 
N

Niek Otten

From Excel HELP:

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

Bernard Liengme

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.
 
W

Warren

Thanks Niek - its working now!
--
Warren B


Niek Otten said:
From Excel HELP:

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