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