Understanding how much a bond truly earns over its lifetime is a fundamental part of fixed-income investing. The YIELD  function in Excel...

ODDLYIELD stands for "Odd Last Period Yield". It calculates the annual yield of a bond when the last period before maturity is irregular — either shorter or longer than a normal coupon schedule. In simple words: If a bond’s last payment doesn't fit into a clean, regular schedule, ODDLYIELD helps you find the true return you will earn.