date and bond calculations

[saturnin02]

Win XP HE, XL 2002 - follow-up: microsoft.public.excel.misc
Hi,
What is the best way to enter a maturity date to calculate PRICE function?
If I am not looking at an actual bond with a stated maturity date but I want
to run a theoretical one, using today's date as settlement (I can use
function today() here) but maturity I wd like to say today + 10 years for
example; instead of having to input the actual date 2015,4,29 for example,
is there a way of using s'thing similar to today()+10 years or today +
(360*10), etc. and how would one actually enter it in the formula (price for
example)?
Tx!
Also, is there a way to extend bond price calculation functions in excel,
some free add-ins, etc.?
Tx?
S

 

[N Harkawat]

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126

 

[N Harkawat]

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126

 

[Guest]

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126

 

[saturnin02]

Thanks for the EDATE. Seems good.
S

using the edate function I found the price of a 100 face yielding 6% and
coupon 5 % semiannual redeming in 10 years
=PRICE(TODAY(),EDATE(TODAY(),10*12),5%,6%,100,2)
=92.56126