<\/p>\n
Syntax<\/h3>\n
DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Examples make the understanding process much easier when learning new concepts. So, let go ahead and dive into a few of them. Please see the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/DURATION-formula-1.png” alt=”DURATION formula 1″ title_text=”DURATION formula 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n For\u00a0<\/span>settlement<\/strong>\u00a0<\/span>and\u00a0<\/span>maturity<\/strong>\u00a0<\/span>parameters, we need to ensure they get valid dates. They can either be results returned from formulas such as\u00a0<\/span>DATE<\/a>,\u00a0<\/span>TO_DATE<\/a>, or references to other date\u00a0type cells. Google Sheets may return parsing errors if we enter direct text values for dates.<\/p>\n The other parameters \u2013\u00a0<\/span>rate<\/strong>,\u00a0<\/span>yield<\/strong>,\u00a0<\/span>frequency<\/strong>, and\u00a0<\/span>day_count_convention\u00a0<\/strong>\u2013 can be direct numeric values or can be references to the cells holding the appropriate values. This is demonstrated in the examples above.<\/p>\n We will observe that all the initial five parameters are the same essentially, yet the output values vary across the examples. This is due to the method with which the days are counted which we indicated using the\u00a0day_count_convention<\/strong>\u00a0<\/span>parameter.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! Use the DURATION formula in Google Sheets to calculate the number of compounding periods that an investment required to reach a target value.<\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on the MDURATION formula in Google Sheets.<\/span><\/a><\/p>\n Alternatively, check out related blog posts below!<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Do you need to calculate the number of compounding periods that an investment required to reach a target value? The\u00a0DURATION\u00a0formula in Google Sheets can help us with that. It considers the present value of an investment as well as the rate of appreciation to arrive at the duration. Syntax DURATION(settlement, maturity, rate, yield, frequency, […]<\/p>\n","protected":false},"author":40,"featured_media":8308,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Do you need to calculate the number of compounding periods that an investment required to reach a target value? The DURATION<\/a> formula in Google Sheets can help us with that. It considers the present value of an investment as well as the rate of appreciation to arrive at the duration.\n\n
\n
Usage: DURATION formula in Google Sheets<\/h3>\n
DURATION formula<\/h3>\n
Syntax<\/h3>\nDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention])<\/strong>\n
\n \t
\n \t
Usage: DURATION formula in Google Sheets<\/h3>\nExamples make the understanding process much easier when learning new concepts. So, let go ahead and dive into a few of them. Please see the snapshot below.\n\n
![\"1.](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/1.-DURATION-formula-Illustration-Frame-1.png\")
\n\nFor settlement<\/strong> and maturity<\/strong> parameters, we need to ensure they get valid dates. They can either be results returned from formulas such as DATE<\/a>, TO_DATE<\/a>, or references to other date type cells. Google Sheets may return parsing errors if we enter direct text values for dates.\n\nThe other parameters - rate<\/strong>, yield<\/strong>, frequency<\/strong>, and day_count_convention <\/strong>- can be direct numeric values or can be references to the cells holding the appropriate values. This is demonstrated in the examples above.\n\nWe will observe that all the initial five parameters are the same essentially, yet the output values vary across the examples. This is due to the method with which the days are counted which we indicated using the day_count_convention<\/strong> parameter.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=8307"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8307\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8308"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}