The MDURATION function in Excel calculates the modified Macaulay duration of a security (such as a bond) that pays periodic interest. In simple words:MDURATION measures the price sensitivity of a bond to changes in interest rates, adjusting for how often the bond pays interest. It’s mainly used by investors, portfolio managers, and financial analysts to assess interest rate risk.