Mike

I have a problem with excel recignising the date in the XNPV formula. It
returns the #name? error. What do I need to do to solve this error?
--
Warren B


"Mike Middleton" wrote:

Stan -

Is there something about the Help description for XNPV that is not clear?
XNPV "Returns the net present value for a schedule of cash flows that is not
necessarily periodic. To calculate the net present value for a series of
cash flows that is periodic, use the NPV function."

For XNPV you must specify dates for the cash flows. For NPV the cash flows
are assumed to be equally-spaced time intervals.

- Mike
www.mikemiddleton.com

"Stan" wrote in message
...
Can someone explain what "XNPV" does? How is it difference from "NPV"?
Thanks.Stan