Formulas > =DURATION()

How To Use DURATION() Function in Google Sheets


Calculates the number of compounding periods required for an investment of a specified present value appreciating at a given rate to reach a target value.

Common questions about the DURATION formula include:
What exactly does the DURATION formula do and what are its parameters?
How do I input dates in the DURATION formula?

The DURATION formula can be used appropriately to calculate the number of days, months, or years between two dates.

The DURATION formula can be commonly mistyped by accidentally mistyping the syntax or format for the formula.

Some common ways the DURATION formula is used inappropriately include attempting to use the formula with non-date values or placing the dates in the wrong order.

Common pitfalls when using the DURATION formula include forgetting any applicable leap years or Daylight Savings Time when making calculations.

Common mistakes when using the DURATION Formula include entering date values in a format other than the ISO 8601 standard.

Common misconceptions people might have with the DURATION Formula include thinking the formula will automatically account for leap years or time zone adjustments.

How To Actually Use DURATION() in Sheets

DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) .

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Generate a DURATION() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.