# Google Sheets DURATION Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/duration-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The DURATION function calculates the duration between two dates in a specified unit, returning the result as a decimal number. ``` DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) . ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the DURATION you need in plain EnglishGenerate Formula ## Parameters **`settlement`**:\ The date when the bond is purchased or the investment is made. **`maturity`**:\ The date when the bond or investment matures and the principal is repaid. **`rate`**:\ The annual coupon rate of the bond expressed as a decimal. **`yield`**:\ The annual yield of the bond expressed as a decimal. **`frequency`**:\ The number of coupon payments per year (e.g., 1 for annual, 2 for semi-annual, 4 for quarterly). **`[day_count_convention]`**:\ An optional parameter that specifies the day count convention to use for the calculation (e.g., 0 for US (NASD) 30/360, 1 for Actual/Actual, etc.). ## What is the DURATION Function? The *DURATION* function in Google Sheets is a useful tool for calculating the duration of a financial instrument, such as a bond, based on its cash flows and yield. It measures the sensitivity of the price of a bond to changes in interest rates, providing investors with insight into the bond's risk profile. In simpler terms, DURATION helps you understand how much the price of a bond is likely to change when interest rates fluctuate. ## A Practical Example Imagine you are analyzing a bond investment with the following details: ### Bond Details: | Cash Flow | Year | | - | - | | 100 | 1 | | 100 | 2 | | 100 | 3 | | 100 | 4 | | 1100 | 5 | You want to calculate the duration of this bond given a yield of 5%. ## DURATION Formula To achieve this, you would use the DURATION function as follows: ``` =DURATION("2023-01-01", "2028-01-01", 0.05, 100, 0, 1) ``` In this formula: - `"2023-01-01"` is the settlement date. - `"2028-01-01"` is the maturity date of the bond. - `0.05` is the yield (5%). - `100` is the face value of the bond. - `0` indicates that the bond pays interest annually. - `1` specifies that the bond is a standard bond. ## Result of the Formula When you apply the DURATION formula, it will return a numeric value representing the duration of the bond. For example, the output might look like this: | Bond Duration | | - | | 4.5 | This indicates that the bond has a duration of 4.5 years, meaning that for a 1% change in interest rates, the bond's price would change approximately 4.5%. ## Why Use DURATION? DURATION is beneficial because it provides a quantitative measure of interest rate risk associated with a bond. It helps investors make informed decisions about their bond investments by understanding how sensitive their bond's price is to changes in interest rates. Additionally, it allows for better portfolio management by balancing the risk and return profile of fixed-income investments. ## Key Takeaways: - **DURATION**: A financial function that calculates the sensitivity of a bond's price to changes in interest rates. - **Risk Assessment**: Helps investors assess the interest rate risk associated with their bond investments. - **Portfolio Management**: Aids in making informed decisions about balancing risk and return in fixed-income portfolios. - **Common Use Cases**: Ideal for bond analysis, portfolio management, and financial modeling. DURATION is an essential function for anyone involved in bond investing, providing valuable insights into the dynamics of interest rate risk and helping to enhance investment strategies. Happy investing! ## Example use case You have a table with start and end dates of projects in Columns A and B. Using the DURATION formula, you can calculate the total time spent on each project in days. This helps in tracking project timelines and managing resources effectively. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.