Skip to content
Google Sheets

INTRATE function in Google Sheets

Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.

=INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention])

INTRATE syntax and parameters

Five arguments, four required.

  • buy_dateanyRequired

    The date of purchase of the investment.

  • sell_dateanyRequired

    The date of sale of the investment.

  • buy_pricenumberRequired

    The price at which the investment was purchased.

  • sell_pricenumberRequired

    The price at which the investment was sold.

  • day_count_conventionnumberOptional

    [ OPTIONAL - 0 by default ] - An indicator of what day count method to use. 0 indicates US (NASD) 30/360 - This assumes 30 day months and 360 day years as per the National Association of Securities Dealers standard, and performs specific adjustments to entered dates which fall at the end of months. 1 indicates Actual/Actual - This calculates based upon the actual number of days between the specified dates, and the actual number of days in the intervening years. Used for US Treasury Bonds and Bills, but also the most relevant for non-financial use. 2 indicates Actual/360 - This calculates based on the actual number of days between the speficied dates, but assumes a 360 day year. 3 indicates Actual/365 - This calculates based on the actual number of days between the specified dates, but assumes a 365 day year. 4 indicates European 30/360 - Similar to 0, this calculates based on a 30 day month and 360 day year, but adjusts end-of-month dates according to European financial conventions.

INTRATE examples

Formulas you'll actually reuse.

  1. The simple annual interest rate of buying at 98,862.50 and receiving 100,000, actual/360:

    =INTRATE(DATE(2026, 3, 15), DATE(2026, 6, 14), 98862.5, 100000, 2)

    Result0.0455

  2. The same on actual/actual (1):

    =INTRATE(B2, C2, D2, E2, 1)

INTRATE in Excel

Same name — your formula ports as-is.

Try INTRATE in the playground

Edit the example — nothing to install.

Preloaded with the INTRATE formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.