If you want a present value, just use PV, as in:

=PV(5%,(Date(2009,1,1)-today())/365,0,-2)

To determine why you got a #NAME error with XNPV, lookup XNPV in help.

Regards,
Fred.

"Will" wrote in message
...
I want to get a present value of:

Amount: $2
Date of Payment: 1/1/2009
Discount Rate: 5%

I tried to use XNPV for this with:

XNPV(Discount,Amount,Date)

but it gives a #NAME? error.

Is my usage incorrect, or is this the wrong function for what I want here?

--
Will