What is DURATION function in Excel? DURATION function is one of the Financial functions in Microsoft Excel that returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price’s response to changes in yield. Syntax of DURATION…