{"id":76,"date":"2016-03-01T04:47:01","date_gmt":"2016-03-01T04:47:01","guid":{"rendered":"https:\/\/www.dynamicwebtraining.com.au\/blog\/?p=76"},"modified":"2024-11-15T15:53:11","modified_gmt":"2024-11-15T04:53:11","slug":"date-function-excel","status":"publish","type":"post","link":"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel","title":{"rendered":"The DATE Function in Excel"},"content":{"rendered":"\n

The DATE<\/strong><\/em> function in Microsoft Excel is used to assemble a date from three separate pieces of data, being the year<\/strong>, month<\/strong><\/em> and day<\/strong><\/em>. This is useful if the information is provided in separate columns and you need to combine them. DATE<\/strong><\/em> will take the year, month and day and convert them to a single serial number representing the date. The result is automatically formatted as a date.
The general function to convert numbers<\/strong> into a date<\/strong> is =DATE(year, month, day)<\/strong><\/em>.
Ensure that the data you are working with in your Excel worksheet looks similar to the screen capture in Step 1<\/strong><\/em>.<\/p>\n\n\n\n\n\n\n\n

Date Function: How-to<\/h2>\n\n\n\n

STEP<\/span> 1<\/span><\/strong>:<\/p>\n\n\n\n

Select cell E6<\/strong>, then type in =DATE(D6,C6,B6)<\/strong>. Press CTRL+ ENTER<\/span> to enter the formula.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 2<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Double-click on the fill handle to copy the formula from cell E6<\/strong> down to cell E10<\/strong>.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 3<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Continue on to click in cell G6<\/strong> and type =E6+(365.25*F6)<\/strong>, then press CTRL+ ENTER<\/span> to enter the formula.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 4<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Click on the HOME<\/strong> tab, click on the drop arrow for the Number Format<\/strong> in the Number group, and then click on Short Date<\/strong>.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

STEP 5<\/span><\/strong><\/span>:<\/p>\n\n\n\n

Double-click on the fill handle to copy the formula from cell G6 down to cell G10.<\/p>\n\n\n\n

\n
\"Excel
Click image to enlarge <\/i><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n

Handy To Know<\/strong><\/span><\/p>\n\n\n\n

When you type a date<\/strong> into a worksheet, Excel automatically recognises and displays it as a date while recording it as a serial number.<\/p>\n\n\n\n

The DATE function topic is covered in our Intermediate Excel course<\/a><\/p>\n\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

The DATE function in Microsoft Excel is used to assemble a date from three separate pieces of data, being the year, month and day. This is useful if the information is provided in separate columns and you need to combine them. DATE will take the year, month and day and convert them to a single…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-76","post","type-post","status-publish","format-standard","hentry","category-microsoft-excel"],"yoast_head":"The DATE Function in Excel - Dynamic Web Training Blog<\/title>\n<meta name=\"description\" content=\"View and Share Dynamic Web Training Blog Archives. This is a great source of articles and posts on Computer and IT training, tutorials and insights\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The DATE Function in Excel - Dynamic Web Training Blog\" \/>\n<meta property=\"og:description\" content=\"Learn how to use the DATE function in Microsoft Excel to assemble a date from three separate pieces of data, being the year, month and day.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\" \/>\n<meta property=\"og:site_name\" content=\"Dynamic Web Training Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/DynamicWebTraining\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-01T04:47:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-15T04:53:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelDateFunction-1-DynamicWebTraining.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@dynamicwebtrain\" \/>\n<meta name=\"twitter:site\" content=\"@dynamicwebtrain\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\",\"name\":\"Dynamic Web Training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/02\/logo.png\",\"width\":361,\"height\":109,\"caption\":\"Dynamic Web Training\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/\",\"name\":\"Dynamic Web Training Blog\",\"description\":\"The Ultimate Training Experience.\",\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-content\/uploads\/2016\/03\/ExcelDateFunction-1-DynamicWebTraining.jpg\",\"width\":723,\"height\":304},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#webpage\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\",\"name\":\"The DATE Function in Excel - Dynamic Web Training Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#primaryimage\"},\"datePublished\":\"2016-03-01T04:47:01+00:00\",\"dateModified\":\"2024-11-15T04:53:11+00:00\",\"description\":\"Learn how to use the DATE function in Microsoft Excel to assemble a date from three separate pieces of data, being the year, month and day.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\",\"name\":\"Training Blog\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\",\"name\":\"Training\"}},{\"@type\":\"ListItem\",\"position\":3,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/category\/training\/microsoft-excel\",\"name\":\"Microsoft Excel\"}},{\"@type\":\"ListItem\",\"position\":4,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\",\"url\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel\",\"name\":\"The DATE Function in Excel\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#webpage\"},\"author\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\"},\"headline\":\"The DATE Function in Excel\",\"datePublished\":\"2016-03-01T04:47:01+00:00\",\"dateModified\":\"2024-11-15T04:53:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/date-function-excel#primaryimage\"},\"articleSection\":\"Microsoft Excel\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#\/schema\/person\/c94653aed4a6decc8e357af0a1082233\",\"name\":\"Dynamic Web Training\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.dynamicwebtraining.com.au\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0a14e92e62ad4eee0843f5cf7da3a00e1df4c9763922d4d20ba3ed2402a6896d?s=96&d=mm&r=g\",\"caption\":\"Dynamic Web Training\"},\"description\":\"Dynamic Web Training is Australia's leading provider of instructor led software training. We offer training courses in Adobe, Web Design, Graphic Design, Photoshop, InDesign, Dreamweaver and many more.\",\"sameAs\":[\"https:\/\/www.facebook.com\/DynamicWebTraining\/\",\"https:\/\/www.linkedin.com\/company\/dynamic-web-training\",\"https:\/\/twitter.com\/dynamicwebtrain\"]}]}<\/script>","_links":{"self":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/76","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/comments?post=76"}],"version-history":[{"count":7,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/76\/revisions"}],"predecessor-version":[{"id":2022,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/posts\/76\/revisions\/2022"}],"wp:attachment":[{"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/media?parent=76"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/categories?post=76"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dynamicwebtraining.com.au\/blog\/wp-json\/wp\/v2\/tags?post=76"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}