The DURATION function in Excel calculates the Macaulay duration of a bond, which is the weighted average time until a bond's cash flows are received. It represents the bond’s interest rate sensitivity or how much the bond price will change with changes in interest rates.