{"id":1193,"date":"2018-07-02T16:57:46","date_gmt":"2018-07-02T16:57:46","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1193"},"modified":"2023-11-02T19:43:00","modified_gmt":"2023-11-02T19:43:00","slug":"edate","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/edate\/","title":{"rendered":"EDATE function"},"content":{"rendered":"\n<p>EDATE function in Excel allows you to calculate the date that is a specified number of months before or after a given date. It&#8217;s a handy tool for various financial and date-related calculations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>EDATE(start_date, months)<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><b>start_date<\/b><\/td><td>The initial date from which you want to calculate the new date.<\/td><\/tr><tr><td><b>months<\/b><\/td><td>The number of months to add (positive value) or subtract (negative value) from the start_date.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use<\/h2>\n\n\n\n<p>You can use the EDATE function in Excel to perform various date-related calculations. Here are some examples:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EDATE(\"2023-11-02\", 3)<\/code><\/pre>\n\n\n\n<p>This formula adds 3 months to the date &#8220;2023-11-02&#8221; and returns &#8220;2024-02-02.&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EDATE(\"2023-11-02\", -2)<\/code><\/pre>\n\n\n\n<p>This formula subtracts 2 months from the date &#8220;2023-11-02&#8221; and returns &#8220;2023-09-02.&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=EDATE(\"2023-11-02\", 12)<\/code><\/pre>\n\n\n\n<p>This formula adds 12 months to the date &#8220;2023-11-02&#8221; and returns &#8220;2024-11-02.&#8221;<\/p>\n\n\n\n<p>Remember to format your cells as dates to display the results properly.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Examples<\/h2>\n\n\n\n<p>Here are some more examples of how to use the EDATE function:<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><b>Formula<\/b><\/td><td><b>Result<\/b><\/td><\/tr><tr><td>=EDATE(&#8220;2023-11-02&#8221;, 6)<\/td><td>2024-05-02<\/td><\/tr><tr><td>=EDATE(&#8220;2023-11-02&#8221;, -4)<\/td><td>2023-07-02<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>If you need to perform more complex date calculations or deal with irregular months, you can combine the EDATE function with other date functions in Excel. Additionally, remember that Excel stores dates as serial numbers, with January 1, 1900, as 1. Therefore, negative months can take you back before that date, so be cautious when using negative values for months.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>EDATE function in Excel allows you to calculate the date that is a specified number of months before or after a given date&#8230;.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>EDATE function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/edate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"EDATE function\" \/>\n<meta property=\"og:description\" content=\"EDATE function in Excel allows you to calculate the date that is a specified number of months before or after a given date....\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/edate\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T16:57:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T19:43:00+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"EDATE function\",\"datePublished\":\"2018-07-02T16:57:46+00:00\",\"dateModified\":\"2023-11-02T19:43:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/\"},\"wordCount\":229,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/\",\"name\":\"EDATE function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T16:57:46+00:00\",\"dateModified\":\"2023-11-02T19:43:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/edate\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/edate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"EDATE function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"EDATE function","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/functions\/edate\/","og_locale":"en_US","og_type":"article","og_title":"EDATE function","og_description":"EDATE function in Excel allows you to calculate the date that is a specified number of months before or after a given date....","og_url":"https:\/\/officetuts.net\/excel\/functions\/edate\/","article_published_time":"2018-07-02T16:57:46+00:00","article_modified_time":"2023-11-02T19:43:00+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"EDATE function","datePublished":"2018-07-02T16:57:46+00:00","dateModified":"2023-11-02T19:43:00+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/"},"wordCount":229,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/","url":"https:\/\/officetuts.net\/excel\/functions\/edate\/","name":"EDATE function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T16:57:46+00:00","dateModified":"2023-11-02T19:43:00+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/edate\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/edate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"EDATE function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1193"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1193"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1193\/revisions"}],"predecessor-version":[{"id":16384,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1193\/revisions\/16384"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}