The INTRATE function in Excel calculates the interest rate for a fully invested security between two dates. It is mainly used for short-term investments, such as Treasury bills, where the security does not pay periodic interest (zero-coupon bonds). In simple words: It finds the simple interest rate earned over a specific period.