Syntax<\/h3>\n
EDATE(start_date, months)<\/strong><\/span><\/p>\n <\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us understand it\u2019s working by making use of a few examples. Please consider the snapshot below. Please note that we have preset the Result column format to \u201cdd-mmm-yyyy\u201d, for the purposes of avoiding ambiguity (given that the date notations varies across countries).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/EDATE-formula-1.png” alt=”EDATE formula 1″ title_text=”EDATE 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 In the first example case, the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>parameter takes in the output that the\u00a0<\/span>DATE() function<\/a>\u00a0<\/span>returned. And we have set the\u00a0<\/span>months<\/strong><\/span>\u00a0<\/span>parameter to \u20184\u2019. Therefore, the formula calculates the result date that is 4 months ahead of 15-Mar-2017.<\/p>\n The second example is pretty similar, except for the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>parameter, we provided a reference to the cell that has a date.<\/p>\n Unlike the previous two cases, the\u00a0<\/span>start_date<\/strong><\/span>\u00a0<\/span>for the third case is an absolute number. And also, we have keyed in a negative value for the\u00a0<\/span>month\u2019s<\/strong><\/span>\u00a0<\/span>parameter. The EDATE formula calculates the resulting date by shifting the time from the date value 42846 (equivalent to 21-Apr-2017) back by nine months.<\/p>\n Let us take a look at the fourth case. At the time of writing this post, the date was 21-Apr-2017 (which, the TODAY() function evaluated to in the second example). Factoring a shift of 45 days we added to the TODAY() function, along with a value of -38 for\u00a0<\/span>months<\/strong><\/span>\u00a0<\/span>parameter, we get the last date of the month as 05-Apr-2014.<\/p>\n Let us experiment a little further and input text based date values for the\u00a0<\/span>start_date<\/strong><\/span>parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/EDATE-formula-2.png” alt=”EDATE formula 2″ title_text=”EDATE formula 2″ _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 In the first example, the formula truncates the decimal values and uses only the integer values and accordingly evaluates the resulting date. Of course, it cannot accept negative numbers, as there is no date interpretation for such values.<\/p>\n From the next three examples, we will that the EDATE formula accepts input date strings in the \u201cdd-mmm-yyyy\u201d and \u201cmm-dd-yyyy\u201d formats. But it will throw up an error with \u201cdd-mm-yyyy\u201d date format strings.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" In Google Sheets application, if we need to know the date a specified number of months before or after a given date, the\u00a0EDATE\u00a0formula can help us do so. Syntax EDATE(start_date, months) start_date\u00a0\u2013 is the date that the EDATE formula calculates the prior or later date separated by the specified number of\u00a0months. months\u00a0\u2013 is the number […]<\/p>\n","protected":false},"author":40,"featured_media":4198,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"In Google Sheets application, if we need to know the date a specified number of months before or after a given date, the EDATE<\/a> formula can help us do so.\n\n
Usage: EDATE Formula<\/h3>\n
Cases of interest<\/h5>\n
Syntax<\/h3>\nEDATE(start_date, months)<\/strong><\/span>\n
\n \t
Usage: EDATE Formula<\/h3>\nLet us understand it's working by making use of a few examples. Please consider the snapshot below. Please note that we have preset the Result column format to \"dd-mmm-yyyy\", for the purposes of avoiding ambiguity (given that the date notations varies across countries).\n\n
![\"EDATE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-16.png\")
\n\nIn the first example case, the start_date<\/strong><\/span> parameter takes in the output that the DATE() function returned. And we have set the months<\/strong><\/span> parameter to '4'. Therefore, the formula calculates the result date that is 4 months ahead of 15-Mar-2017.\n\nThe second example is pretty similar, except for the start_date<\/strong><\/span> parameter, we provided a reference to the cell that has a date.\n\nUnlike the previous two cases, the start_date<\/strong><\/span> for the third case is an absolute number. And also, we have keyed in a negative value for the month's<\/strong><\/span> parameter. The EDATE formula calculates the resulting date by shifting the time from the date value 42846 (equivalent to 21-Apr-2017) back by nine months.\n\nLet us take a look at the fourth case. At the time of writing this post, the date was 21-Apr-2017 (which, the TODAY() function evaluated to in the second example). Factoring a shift of 45 days we added to the TODAY() function, along with a value of -38 for months<\/strong><\/span> parameter, we get the last date of the month as 05-Apr-2014.\nCases of interest<\/h5>\nLet us experiment a little further and input text based date values for the start_date<\/strong><\/span> parameter.\n\n
![\"EDATE](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/10\/frame-generic-17.png\")
\n\nIn the first example, the formula truncates the decimal values and uses only the integer values and accordingly evaluates the resulting date. Of course, it cannot accept negative numbers, as there is no date interpretation for such values.\n\nFrom the next three examples, we will that the EDATE formula accepts input date strings in the \"dd-mmm-yyyy\" and \"mm-dd-yyyy\" formats. But it will throw up an error with \"dd-mm-yyyy\" date format strings.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-4119","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\/es\/wp-json\/wp\/v2\/posts\/4119","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=4119"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/4119\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/4198"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=4119"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=4119"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=4119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}