Syntax<\/h3>\n
DAYS360(start_date, end_date, [method])<\/strong><\/p>\n The US method, there are a couple scenarios to consider. If the\u00a0start_date<\/strong>\u00a0<\/span>is the last day of a month, the formula changes it to 30 for the purposes of the calculation. If the\u00a0end_date<\/strong>\u00a0<\/span>is the last day of a month and\u00a0<\/span>start_date<\/strong>\u00a0<\/span>is earlier than the 30th of that month, then the formula changes the\u00a0<\/span>end_date<\/strong>\u00a0<\/span>to the first day of the following month. Otherwise, the formula considers the\u00a0<\/span>end_date<\/strong>\u00a0<\/span>as 30th of that month.<\/p>\n With the European method, it is relatively simple. If any\u00a0<\/span>start_date<\/strong>\u00a0<\/span>or\u00a0<\/span>end_date<\/strong>\u00a0falls on the 31st of a month, then the formula changes it to\u00a030th of that month.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We just learned the way the syntax of the DAYS360 formula works. It is time to dive head-first into applying this practically on the Google Sheets application. Please have a look at the snapshot below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/DAYS360-formula-Illustration-Frame-1.png” alt=”DAYS360 Google Sheets” title_text=”day360-formula-usage” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” 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 In the first example, we notice the output is 90. But if we calculated the actual difference using the\u00a0<\/span>DATEDIF<\/a>\u00a0<\/span>formula, it will give us 91. So, this clearly demonstrates that the financial context to calculate\u00a0how far two dates are from each other is different from the actual context.<\/p>\n While the initial three example formulas used the US method of day counting, the final formula uses the European method.<\/p>\n We encourage you to flex your thinking muscles and analyze how each example formula calculated the difference. You might as well compare each of these with the DATEDIF application to observe the deviations (if any).<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Let\u2019s say we need to know how far two different dates are separated from each other, based on the 360 day year. Probably for the purposes of some financial interest calculations. We can make use of the\u00a0DAYS360\u00a0formula in Google Sheets for this purpose. Please note that formula is supposedly built for use in a financial […]<\/p>\n","protected":false},"author":40,"featured_media":8569,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Let's say we need to know how far two different dates are separated from each other, based on the 360 day year. Probably for the purposes of some financial interest calculations. We can make use of the DAYS360<\/a> formula in Google Sheets for this purpose. Please note that formula is supposedly built for use in a financial setting. Using this in any other context may result in incorrect output values.\n The US method, there are a couple scenarios to consider. If the start_date<\/strong> is the last day of a month, the formula changes it to 30 for the purposes of the calculation. If the end_date<\/strong> is the last day of a month and start_date<\/strong> is earlier than the 30th of that month, then the formula changes the end_date<\/strong> to the first day of the following month. Otherwise, the formula considers the end_date<\/strong> as 30th of that month.<\/p>\n With the European method, it is relatively simple. If any start_date<\/strong> or end_date<\/strong> falls on the 31st of a month, then the formula changes it to 30th of that month.<\/p>\n\n\n
Usage: DAYS360 formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nDAYS360(start_date, end_date, [method])<\/strong>\n
\n \t
Usage: DAYS360 formula in Google Sheets<\/h3>\nWe just learned the way the syntax of the DAYS360 formula works. It is time to dive head-first into applying this practically on the Google Sheets application. Please have a look at the snapshot below.\n\n
![\"DAYS360](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/06\/DAYS360-formula-Illustration-Frame-1.png\")
\n\nIn the first example, we notice the output is 90. But if we calculated the actual difference using the DATEDIF<\/a> formula, it will give us 91. So, this clearly demonstrates that the financial context to calculate how far two dates are from each other is different from the actual context.\n\nWhile the initial three example formulas used the US method of day counting, the final formula uses the European method.\n\nWe encourage you to flex your thinking muscles and analyze how each example formula calculated the difference. You might as well compare each of these with the DATEDIF application to observe the deviations (if any).","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8568","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\/8568","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=8568"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/8568\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/8569"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=8568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=8568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=8568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}