{"id":4058,"date":"2019-01-30T11:10:06","date_gmt":"2019-01-30T11:10:06","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4058"},"modified":"2024-03-26T11:28:47","modified_gmt":"2024-03-26T11:28:47","slug":"convert-text-or-number-to-date","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/","title":{"rendered":"Convert Text or Number to Date in Excel"},"content":{"rendered":"\n

In this lesson, I\u2019ll\nshow you how to convert text to dates in Excel in a formula and non-formula\nway.<\/p>\n\n\n\n

When you import data to Excel, it may come in many different\nforms, with different delimiters. It\u2019s also important to be aware of dates\nnotation used in a particular country.\nFor example, people in the USA use different date format<\/a>\nthan the rest of the world.<\/p>\n\n\n\n

There are many ways to convert text to date<\/a>. I\u2019ll show you all of them so you can choose a conversion technique that is most suitable in a given situation.<\/p>\n\n\n\n

Check whether a value is a DATE or\nTEXT<\/h2>\n\n\n\n

It\u2019s impossible to\nknow whether a particular value is a date or text by looking at a spreadsheet.\nYou have to check them. We can do it by using the ISTEXT<\/a>\nfunction.<\/p>\n\n\n\n

This function returns TRUE<\/strong>\nif the value is text, and FALSE<\/strong>\notherwise. <\/p>\n\n\n\n

Take a look at the following example. In column A<\/strong>, there are dates, but some of them\nare formatted as text and the other ones as dates.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you press Ctrl + `<\/strong>\n(grave accent), you are going to notice how these values are stored.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also check whether\nthe text is formatted as a date by clicking it and looking at Home >> Number<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You have to be careful here. If you place a single\napostrophe (\u2018) before date (or any other value or formula), Excel will treat it\nas text, even when the number format in Home\n>> Number<\/strong> shows DATE<\/strong>.<\/p>\n\n\n\n

This apostrophe will be only visible inside the formula bar<\/a>\nand not in a cell. The ISTEXT<\/strong>\nfunction will return TRUE<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How to convert a number to date<\/h2>\n\n\n\n

There is no DATE<\/strong>\ntype in Excel. Dates are numbers formatted<\/a> to dates.<\/p>\n\n\n\n

The following example has numbers in column A<\/strong>, and the same numbers formatted as\ndates in column B<\/strong>. Increasing the\nnumber by 1, increases the date by one day, starting from 1\/1\/1900<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

 If you want to know more about the way Excel stores dates read the following article<\/a>.<\/p>\n\n\n\n

Change the date format<\/h2>\n\n\n\n

I\u2019m going to show you two ways you can change the date format<\/a>.\n<\/p>\n\n\n\n

Use the TEXT function <\/h3>\n\n\n\n

If you want to change the date format and then convert it to\ntext, you can do it with the TEXT function<\/a>.<\/p>\n\n\n\n

This function converts a value\nto text in a specific format.<\/p>\n\n\n\n

=TEXT(A2,\"dd-mm-yyyy\")<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Format Cells window<\/h3>\n\n\n\n
If you want to change the format of existing dates<\/a>, without\nconverting them to text, you can do it by accessing the Format Cells window.<\/p>\n\n\n\n
Select the cells you want to change the format and press Ctrl + 1<\/strong>.<\/p>\n\n\n\n
Under the Date<\/strong>\ncategory, you can choose a country and a format you want to use. Choose d-m-yyyy<\/strong>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
This is the result we get.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Change text to date<\/h2>\n\n\n\n
If you have a date in a form of text, you can\u2019t change it to\ndifferent date format. First, you have to convert it to a number and then to date<\/a>.<\/p>\n\n\n\n
The DATEVALUE function<\/a>\ntakes a single argument, which is a date in a form of text.<\/p>\n\n\n\n
Then the function converts this text to a number. The number\ncan be later converted to date with different date format.<\/p>\n\n\n\n
=DATEVALUE(A2)<\/pre>\n\n\n\n
\"\"<\/figure>\n\n\n\n
If you want to change a date to a number, you can use the VALUE function<\/a> instead.<\/p>\n\n\n\n
Convert 8-digit number to date<\/h2>\n\n\n\n
When you receive a file with dates written as an 8-digit\nnumber, first you have to recognize the country date\nformats<\/a> (YMD, DMY, MDY). If you have many examples, it’s easy to figure it out.<\/p>\n\n\n\n
\n  YMD<\/strong>\n  <\/td>\n  DMY<\/strong>\n  <\/td>\n  MDY<\/strong>\n  <\/td><\/tr>
\n  20160101\n  <\/td>\n  11012011\n  <\/td>\n  11112018\n  <\/td><\/tr>
\n  20090520\n  <\/td>\n  21102016\n  <\/td>\n  07032017\n  <\/td><\/tr>
\n  20191127\n  <\/td>\n  07012009\n  <\/td>\n  11212016\n  <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
If you just copy and paste<\/a> the table, you will get this result.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Cells B4<\/strong> and C3<\/strong> don\u2019t have leading zeros<\/a>. That\u2019s\nbecause Excel removes them by default. Even if you copy cells as text, the\nzeros will be removed. You can format cells as text and add zeros by hand, but\nthere is a better way to do this.<\/p>\n\n\n\n
Before copying cells, select empty cells where the values will be copied, right-click and choose Format Cells<\/strong>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
You can also use the Ctrl\n+ 1<\/strong> keyboard shortcut.<\/p>\n\n\n\n
In the Category window, select Text<\/strong>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click OK<\/strong>.<\/p>\n\n\n\n
Copy the table and paste it into Excel<\/a> worksheet with Match destination formatting<\/strong> option.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
After you paste these values, don\u2019t forget to convert the\nrest of them to the General<\/strong> format.<\/p>\n\n\n\n
Now, the leading zeros<\/a> are in place and we can create our formulas. We are going to convert text to date using the DATE function<\/a>.<\/p>\n\n\n\n
The MID function<\/h3>\n\n\n\n
In this formula, we are going to use the MID\nfunction<\/a> to separate values into days, months and years.<\/p>\n\n\n\n
\n  YMD<\/strong>\n  <\/td>\n  Result YMD<\/strong>\n  <\/td><\/tr>
\n  =DATE(MID(A2,1,4),MID(A2,5,2),MID(A2,7,2))\n  <\/td>\n  1\/1\/2016\n  <\/td><\/tr>
\n  DMY<\/strong>\n  <\/td>\n  Result DMY<\/strong>\n  <\/td><\/tr>
\n  =DATE(MID(B2,5,4),MID(B2,3,2),MID(B2,1,2))\n  <\/td>\n  1\/11\/2011\n  <\/td><\/tr>
\n  MDY<\/strong>\n  <\/td>\n  Result MDY<\/strong>\n  <\/td><\/tr>
\n  =DATE(MID(C2,5,4),MID(C2,1,2),MID(C2,3,2))\n  <\/td>\n  11\/11\/2018\n  <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
The LEFT, MID and RIGHT functions<\/h3>\n\n\n\n
In the second method, we will use two additional functions: LEFT<\/a>\nand RIGHT<\/a>. This\nformula is more readable because these\ntwo functions take two parameters,\ninstead of three.<\/p>\n\n\n\n
\n  YMD<\/strong>\n  <\/td>\n  Result YMD<\/strong>\n  <\/td><\/tr>
\n  =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))\n  <\/td>\n  1\/1\/2016\n  <\/td><\/tr>
\n  DMY<\/strong>\n  <\/td>\n  Result DMY<\/strong>\n  <\/td><\/tr>
\n  =DATE(RIGHT(B2,4),MID(B2,3,2),LEFT(B2,2))\n  <\/td>\n  1\/11\/2011\n  <\/td><\/tr>
\n  MDY<\/strong>\n  <\/td>\n  Result MDY<\/strong>\n  <\/td><\/tr>
\n  =DATE(RIGHT(C2,4),LEFT(C2,2),MID(C2,3,2))\n  <\/td>\n  11\/11\/2018\n  <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
When we use Text to Columns Wizard<\/a>, we usually specify a delimiter. But here, we don\u2019t have any. There is another option you can use to separate values, called Fixed width<\/strong>. We can use this feature because we have a consistent width of 8 digits.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click Next<\/strong>. <\/p>\n\n\n\n
Create two lines separating the values.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click Finish. We don\u2019t have to go to step 3. Our data will be converted to the General<\/strong> type.<\/p>\n\n\n\n
Our example will be separated to Day, Month and Year.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Convert 6-digit number to date<\/h2>\n\n\n\n
If you get a list of dates that consists of 6 numbers, you\nhave to modify the formula. If you know that there is no year older than 2000,\nyou can use the following formula for DMY<\/strong>.<\/p>\n\n\n\n
=DATE(20&RIGHT(B2,2),MID(B2,3,2),LEFT(B2,2))<\/pre>\n\n\n\n
This will give you the\nfollowing result.<\/p>\n\n\n\n
1\/11\/2011<\/p>\n\n\n\n
If you don\u2019t place 20&<\/strong>\nbefore the RIGHT function, the year will become 1911, instead of 2011. <\/p>\n\n\n\n
Let\u2019s suppose that you don\u2019t have years before 1980. In this\nformula, we are going to convert every\nyear smaller than 1980 to 2000s and bigger than 80 to 1900s.<\/p>\n\n\n\n
=DATE(IF(INT(RIGHT(A2,2))>=80,19&RIGHT(A2,2),20&RIGHT(A2,2)),MID(A2,3,2),LEFT(A2,2))<\/pre>\n\n\n\n
Formula explanation<\/strong><\/p>\n\n\n\n
The formula converts a\nyear that consist of two digits to an integer.\nIt\u2019s important to convert this to a number\nif you want to do comparisons. Next, it checks whether the number is bigger or\nequal to 80. If it returns TRUE then it adds 19 at the beginning.\nIf it FALSE it adds 20.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Change delimiters<\/h2>\n\n\n\n
Find and Replace<\/h3>\n\n\n\n
If your dates as formatted as text and you have a non-standard delimiter, you can change them\neasily to slashes. <\/p>\n\n\n\n
Take a look at the following example.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
With selected dates (A2:A11)\nuse the Ctrl + H<\/strong>. This keyboard\nshortcut opens the Find and Replace<\/strong>\nwindow. Here, you can replace one character with another.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click Replace All<\/strong>.\nOur table changed and now dates are formatted as dates.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
What happened? Some values converted to dates and the other\nones stayed text. Dates are already converted to the US format (MDY). That\u2019s\nwhy 12.07.2003 changes to date (December) and 23.12.2011 won\u2019t because you\ndon\u2019t have 23rd<\/sup> month.<\/p>\n\n\n\n
We have to make some language and region modifications outside Excel.<\/p>\n\n\n\n
Region and Language settings<\/h2>\n\n\n\n
In the search area start typing \u201cControl Panel\u201d until the\nicon appears.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Make sure that you have the view\nby a category selected.<\/p>\n\n\n\n
Under Clock and\nRegion<\/strong>, select Change date, time, or\nnumber formats<\/strong>. In the Region<\/strong>\nwindow, click Additional Settings<\/strong>.\nNext, choose the Date<\/strong> tab.<\/p>\n\n\n\n
Now, days, months and years are separated by slash instead\nof a dash.<\/p>\n\n\n\n
Modify the Short date<\/strong>\nformat.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Click Apply<\/strong> on\nboth windows.<\/p>\n\n\n\n
Let\u2019s replace the characters one more time. Now, the dates\nare formatted properly.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The SUBSTITUTE function<\/h3>\n\n\n\n
Let\u2019s switch back to the standard\nUS format in the Region settings M\/d\/Y.<\/p>\n\n\n\n
The SUBSTITUTE function<\/a>\nworks in a similar way as Find and\nReplace – it replaces the existing text with a new text in a text string.<\/p>\n\n\n\n
=SUBSTITUTE(A2,\"-\",\"\/\")<\/pre>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
In this lesson, I\u2019ll show you how to convert text to dates in Excel in a formula and non-formula way. When you import…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"\nConvert Text or Number to Date in Excel<\/title>\n<meta name=\"description\" content=\"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.\" \/>\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\/examples\/convert-text-or-number-to-date\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Text or Number to Date in Excel\" \/>\n<meta property=\"og:description\" content=\"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-30T11:10:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:28:47+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png\" \/>\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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Convert Text or Number to Date in Excel\",\"datePublished\":\"2019-01-30T11:10:06+00:00\",\"dateModified\":\"2024-03-26T11:28:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\"},\"wordCount\":1356,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\",\"name\":\"Convert Text or Number to Date in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png\",\"datePublished\":\"2019-01-30T11:10:06+00:00\",\"dateModified\":\"2024-03-26T11:28:47+00:00\",\"description\":\"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Text or Number to Date in Excel\"}]},{\"@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":"Convert Text or Number to Date in Excel","description":"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.","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\/examples\/convert-text-or-number-to-date\/","og_locale":"en_US","og_type":"article","og_title":"Convert Text or Number to Date in Excel","og_description":"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.","og_url":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/","article_published_time":"2019-01-30T11:10:06+00:00","article_modified_time":"2024-03-26T11:28:47+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Convert Text or Number to Date in Excel","datePublished":"2019-01-30T11:10:06+00:00","dateModified":"2024-03-26T11:28:47+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/"},"wordCount":1356,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/","url":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/","name":"Convert Text or Number to Date in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png","datePublished":"2019-01-30T11:10:06+00:00","dateModified":"2024-03-26T11:28:47+00:00","description":"Convert text to dates in Excel: formula and non-formula techniques. Check if a value is a date or text and how to convert a number to a date.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2019\/01\/istext-function.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-text-or-number-to-date\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert Text or Number to Date in Excel"}]},{"@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\/4058"}],"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=4058"}],"version-history":[{"count":16,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4058\/revisions"}],"predecessor-version":[{"id":15479,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/4058\/revisions\/15479"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=4058"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=4058"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=4058"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}