{"id":1111,"date":"2018-07-01T11:09:16","date_gmt":"2018-07-01T11:09:16","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1111"},"modified":"2023-11-02T20:00:04","modified_gmt":"2023-11-02T20:00:04","slug":"date","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/date\/","title":{"rendered":"DATE function"},"content":{"rendered":"\n<p>The Excel DATE function is a useful tool for working with dates in Excel spreadsheets. It allows you to create a valid date based on the provided year, month, and day values. In simple words, you can use the DATE function to build a date by specifying its components.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>DATE(year, month, day)<\/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>year<\/b><\/td><td>The year you want to use in the date. It can be a number, a cell reference, or a formula that returns a year value.<\/td><\/tr><tr><td><b>month<\/b><\/td><td>The month you want to use in the date. It can be a number (1-12), a cell reference, or a formula that returns a month value.<\/td><\/tr><tr><td><b>day<\/b><\/td><td>The day you want to use in the date. It can be a number (1-31), a cell reference, or a formula that returns a day value.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to use<\/h2>\n\n\n\n<p>Let&#8217;s explore how to use the DATE function with a few examples:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=DATE(2023, 11, 2)<\/code><\/pre>\n\n\n\n<p>This formula will return the date November 2, 2023.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=DATE(2023, 2, 29)<\/code><\/pre>\n\n\n\n<p>Using invalid date components will result in an error, as there is no February 29 in a non-leap year.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=DATE(A1, B1, C1)<\/code><\/pre>\n\n\n\n<p>If you have year, month, and day values in cells A1, B1, and C1, respectively, this formula will calculate the date based on those values.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=DATE(2023, 5, 15+7)<\/code><\/pre>\n\n\n\n<p>You can also use arithmetic operations within the DATE function. In this case, it will result in the date May 22, 2023.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional information<\/h2>\n\n\n\n<p>If you&#8217;re working with dates in Excel, the DATE function is a valuable tool for creating custom date values. It&#8217;s essential to ensure that the provided year, month, and day values are accurate to obtain the desired results. If you encounter errors, check the input values to make sure they represent a valid date.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Excel DATE function is a useful tool for working with dates in Excel spreadsheets. It allows you to create a valid 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>DATE 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\/date\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DATE function\" \/>\n<meta property=\"og:description\" content=\"The Excel DATE function is a useful tool for working with dates in Excel spreadsheets. It allows you to create a valid date...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/date\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-01T11:09:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T20:00:04+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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"DATE function\",\"datePublished\":\"2018-07-01T11:09:16+00:00\",\"dateModified\":\"2023-11-02T20:00:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/\"},\"wordCount\":281,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/date\/\",\"name\":\"DATE function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-01T11:09:16+00:00\",\"dateModified\":\"2023-11-02T20:00:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/date\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/date\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DATE 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":"DATE 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\/date\/","og_locale":"en_US","og_type":"article","og_title":"DATE function","og_description":"The Excel DATE function is a useful tool for working with dates in Excel spreadsheets. It allows you to create a valid date...","og_url":"https:\/\/officetuts.net\/excel\/functions\/date\/","article_published_time":"2018-07-01T11:09:16+00:00","article_modified_time":"2023-11-02T20:00:04+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/date\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/date\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"DATE function","datePublished":"2018-07-01T11:09:16+00:00","dateModified":"2023-11-02T20:00:04+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/date\/"},"wordCount":281,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/date\/","url":"https:\/\/officetuts.net\/excel\/functions\/date\/","name":"DATE function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-01T11:09:16+00:00","dateModified":"2023-11-02T20:00:04+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/date\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/date\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/date\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"DATE 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\/1111"}],"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=1111"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1111\/revisions"}],"predecessor-version":[{"id":16402,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1111\/revisions\/16402"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}