ODDFPRICE Function
Returns the price of a bond with an odd (short or long) first coupon period.
Category
Financial
Available in
All versions, Microsoft 365
Returns
A price per $100 face value
Overview
New bonds often have a first coupon period that isn't a normal length — the issue date doesn't line up with the coupon schedule. ODDFPRICE prices them correctly, where PRICE would assume a regular first period.
Prices are quoted per $100 of face value, so 95.10 means you pay $951 for a $1,000 bond.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| settlement | Yes | The date the buyer takes ownership (after the issue date). |
| maturity | Yes | The date the security is repaid. |
| issue | Yes | The date the security was first issued. |
| first_coupon | Yes | The first coupon date. |
| rate | Yes | The annual coupon rate. |
| yld | Yes | The annual yield. |
| redemption | Yes | The value paid at maturity per $100 of face value (usually 100). |
| frequency | Yes | Coupon payments per year: 1 = annual, 2 = semiannual, 4 = quarterly. |
| basis | No | Day count: 0 or omitted = US 30/360, 1 = actual/actual, 2 = actual/360, 3 = actual/365, 4 = European 30/360. |
Examples
Example 1 — A new issue with a long first coupon
A 5.5% bond issued 2/1/2026, first coupon 12/1/2026 (a 10-month first period), maturing 6/1/2034. Northstar buys on 3/15/2026 at a 5.8% yield.
| A | B | |
|---|---|---|
| 1 | Settlement | 3/15/2026 |
| 2 | Maturity | 6/1/2034 |
| 3 | Issue | 2/1/2026 |
| 4 | First coupon | 12/1/2026 |
| 5 | Rate | 5.5% |
| 6 | Yield | 5.8% |
| 7 | Redemption | 100 |
| 8 | Frequency | 2 |
| 9 | Basis | 0 |
| 10 | Price | 98.01 |
Common mistakes
- #NUM! error. The dates must run issue < settlement < first coupon < maturity.
Notes
- Enter dates with DATE or as cells holding real dates. Text dates like "3/15/2026" typed straight into the formula can be misread on computers with other regional settings.
- Related functions: ODDFYIELD, ODDLPRICE, PRICE.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.