Excel has such a function. It's called YIELD. Just look up bond yield in
Help.

Regards,
Fred,

"Gilbert DE CEULAER" wrote in message
...
Has somebody a formula to calculate the exact real return on a bond.
With time to go not just in years, but with exact dates, including
purchasing-costs,...
Thanks in advance.
Gilbert