Excel contains an intrinsic function which is used to measure the duration of a bond. It is called as the DURATION. For that, one needs to enter all the information regarding its settlement date, maturity date, coupon rate, the yield to maturity (YTM), and frequency of coupon pays. The syntax is, =DURATION(settlement, maturity, coupon, ytm, frequency, [basis]) settlement: date of se... https://finxl.in/certified-investment-banking-course.html