{"id":880,"date":"2021-09-23T17:33:39","date_gmt":"2021-09-23T17:33:39","guid":{"rendered":"https:\/\/www.excelandmacros.com\/?p=880"},"modified":"2025-10-13T21:45:44","modified_gmt":"2025-10-13T21:45:44","slug":"conversion-of-dates-from-text-to-date-format","status":"publish","type":"post","link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/data-processing\/conversion-of-dates-from-text-to-date-format\/","title":{"rendered":"Conversion of dates from text to date format"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"880\" class=\"elementor elementor-880\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-99e5b0f elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"99e5b0f\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-48a9451e\" data-id=\"48a9451e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-205697ac elementor-widget elementor-widget-text-editor\" data-id=\"205697ac\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>DATA PROCESSING<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1fa9026e elementor-widget elementor-widget-heading\" data-id=\"1fa9026e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Conversion of dates from text to date format<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-223d23d9 elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"223d23d9\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-43c7af61\" data-id=\"43c7af61\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7bfb30ff elementor-widget elementor-widget-sidebar\" data-id=\"7bfb30ff\" data-element_type=\"widget\" data-widget_type=\"sidebar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div id=\"ocean_social_share-2\" class=\"sidebar-box widget-oceanwp-social-share social-share clr\">\t\t\t\t<ul class=\"owp-social-share style-colored name-hidden\">\r\n\t\t\t\t\t<li class=\"twitter\"><a href=\"https:\/\/twitter.com\/share?text=Conversion%20of%20dates%20from%20text%20to%20date%20format&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fdata-processing%2Fconversion-of-dates-from-text-to-date-format%2F\" title=\"Share on X\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-twitter-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"facebook\"><a href=\"https:\/\/www.facebook.com\/sharer.php?u=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fdata-processing%2Fconversion-of-dates-from-text-to-date-format%2F\" title=\"Share on Facebook\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-facebook-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M504 256C504 119 393 8 256 8S8 119 8 256c0 123.78 90.69 226.38 209.25 245V327.69h-63V256h63v-54.64c0-62.15\t\t\t\t\t\t\t\t37-96.48 93.67-96.48 27.14 0 55.52 4.84 55.52 4.84v61h-31.28c-30.8 0-40.41 19.12-40.41 38.73V256h68.78l-11\t\t\t\t\t\t\t\t71.69h-57.78V501C413.31 482.38 504 379.78 504 256z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"linkedin\"><a href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fwww.excelandmacros.com%2Fsr%2Fmagazine%2Fdata-processing%2Fconversion-of-dates-from-text-to-date-format%2F&#038;title=Conversion%20of%20dates%20from%20text%20to%20date%20format&#038;summary=DATA+PROCESSING+Conversion+of+dates+from+text+to+date+format+Sometimes+it+can+be+hard+to+deal+with+text+and+date+formats+in+Excel.+I+realized+that+probably+conversion+of+dates+from+text+to+date+format+issues+bother+many+of%26hellip%3B&#038;source=https:\/\/www.excelandmacros.com\/sr\/\" title=\"Share on LinkedIn\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-linkedin-icon\" role=\"img\" viewbox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M416 32H31.9C14.3 32 0 46.5 0 64.3v383.4C0 465.5 14.3 480 31.9 480H416c17.6 0 32-14.5 32-32.3V64.3c0-17.8-14.4-32.3-32-32.3zM135.4\t\t\t\t\t\t\t\t416H69V202.2h66.5V416zm-33.2-243c-21.3 0-38.5-17.3-38.5-38.5S80.9 96 102.2 96c21.2 0 38.5 17.3 38.5 38.5 0 21.3-17.2 38.5-38.5 38.5zm282.1\t\t\t\t\t\t\t\t243h-66.4V312c0-24.8-.5-56.7-34.5-56.7-34.6 0-39.9 27-39.9 54.9V416h-66.4V202.2h63.7v29.2h.9c8.9-16.8 30.6-34.5 62.9-34.5 67.2 0 79.7 44.3 79.7 101.9V416z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li><li class=\"viber\"><a href=\"\" title=\"Share on Viber\"  style=\"border-radius:2px;\" onclick=\"owpShareOnClick( this.href );return false;\"><span class=\"owp-icon-wrap\"><svg class=\"owpss-icon\" aria-labelledby=\"owpss-viber-icon\" role=\"img\" viewbox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\">\r\n\t\t\t\t\t\t\t\t<path d=\"M444 49.9C431.3 38.2 379.9.9 265.3.4c0 0-135.1-8.1-200.9 52.3C27.8 89.3 14.9 143 13.5 209.5c-1.4 66.5-3.1 191.1 117\t\t\t\t\t\t\t\t224.9h.1l-.1 51.6s-.8 20.9 13 25.1c16.6 5.2 26.4-10.7 42.3-27.8 8.7-9.4 20.7-23.2 29.8-33.7 82.2 6.9 145.3-8.9 152.5-11.2 16.6-5.4 110.5-17.4\t\t\t\t\t\t\t\t125.7-142 15.8-128.6-7.6-209.8-49.8-246.5zM457.9 287c-12.9 104-89 110.6-103 115.1-6 1.9-61.5 15.7-131.2 11.2 0 0-52 62.7-68.2 79-5.3 5.3-11.1\t\t\t\t\t\t\t\t4.8-11-5.7 0-6.9.4-85.7.4-85.7-.1 0-.1 0 0 0-101.8-28.2-95.8-134.3-94.7-189.8 1.1-55.5 11.6-101 42.6-131.6 55.7-50.5 170.4-43 170.4-43 96.9.4\t\t\t\t\t\t\t\t143.3 29.6 154.1 39.4 35.7 30.6 53.9 103.8 40.6 211.1zm-139-80.8c.4 8.6-12.5 9.2-12.9.6-1.1-22-11.4-32.7-32.6-33.9-8.6-.5-7.8-13.4.7-12.9 27.9\t\t\t\t\t\t\t\t1.5 43.4 17.5 44.8 46.2zm20.3 11.3c1-42.4-25.5-75.6-75.8-79.3-8.5-.6-7.6-13.5.9-12.9 58 4.2 88.9 44.1 87.8 92.5-.1 8.6-13.1 8.2-12.9-.3zm47 13.4c.1\t\t\t\t\t\t\t\t8.6-12.9 8.7-12.9.1-.6-81.5-54.9-125.9-120.8-126.4-8.5-.1-8.5-12.9 0-12.9 73.7.5 133 51.4 133.7 139.2zM374.9 329v.2c-10.8 19-31 40-51.8\t\t\t\t\t\t\t\t33.3l-.2-.3c-21.1-5.9-70.8-31.5-102.2-56.5-16.2-12.8-31-27.9-42.4-42.4-10.3-12.9-20.7-28.2-30.8-46.6-21.3-38.5-26-55.7-26-55.7-6.7-20.8 14.2-41\t\t\t\t\t\t\t\t33.3-51.8h.2c9.2-4.8 18-3.2 23.9 3.9 0 0 12.4 14.8 17.7 22.1 5 6.8 11.7 17.7 15.2 23.8 6.1 10.9 2.3 22-3.7 26.6l-12 9.6c-6.1 4.9-5.3 14-5.3 14s17.8\t\t\t\t\t\t\t\t67.3 84.3 84.3c0 0 9.1.8 14-5.3l9.6-12c4.6-6 15.7-9.8 26.6-3.7 14.7 8.3 33.4 21.2 45.8 32.9 7 5.7 8.6 14.4 3.8 23.6z\"\/>\r\n\t\t\t\t\t\t\t<\/svg><\/span><\/a><\/li>\t\t\t\t<\/ul>\r\n\r\n\t\t\t\t\r\n\t\t\r\n\t\t\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-3658f4c0\" data-id=\"3658f4c0\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5c139fb5 elementor-widget elementor-widget-heading\" data-id=\"5c139fb5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Sometimes it can be hard to deal with text and date formats in Excel.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77d60a75 elementor-widget elementor-widget-text-editor\" data-id=\"77d60a75\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>I realized that probably conversion of dates from text to date format issues bother many of you who use Excel daily. So, I hope these insights below will be useful, and that you will go tomorrow to a job and say: <b>\u201cHey, I know how to make our job easier!\u201d<\/b>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eff5c8e elementor-widget elementor-widget-text-editor\" data-id=\"eff5c8e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Very often you will have a situation in your daily work that you get unprocessed, or to say <b>raw data<\/b>, which you will need to re-arrange before you could really use them.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-35afa76 elementor-widget elementor-widget-text-editor\" data-id=\"35afa76\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>When you process data sheets with dates you will face an issue that you will receive data which are unusable for working with date functions such as Networkdays function or Workday function, due to computer date format incompatible with your computer date format settings.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6e5814 elementor-widget elementor-widget-text-editor\" data-id=\"c6e5814\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>For example, if you use European date format <b>DD.MM.YYYY<\/b> you may face the situation that your Excel cannot recognize dates written in US date format <b>MM\/DD\/YYYY<\/b> especially if data are exported from some other software, put in Excel, and sent to you.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6813ea elementor-widget elementor-widget-text-editor\" data-id=\"d6813ea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Also, there is a situation when some of your colleagues, less skilled in Excel, put the date in regular format DD.MM.YYYY but including <b>a dot after it<\/b>. Excel would not recognize this input as a date, but it would assume that your colleague wanted to insert a text string.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c98ecf elementor-widget elementor-widget-text-editor\" data-id=\"5c98ecf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In order to use dates from that spreadsheet in Date and Time functions you will need to modify initial file so your cells with dates in format of text become dates in format of a real date recognized by Excel. Maybe I confused you now, but here is what I mean:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2cee753d elementor-widget elementor-widget-image\" data-id=\"2cee753d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"749\" height=\"131\" src=\"https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/conversion_from_text_to_date.jpg\" class=\"attachment-large size-large wp-image-957\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1844c0ec elementor-widget elementor-widget-text-editor\" data-id=\"1844c0ec\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>These are just few examples. In real life there are few more typing mistakes and date formats in use which could make similar issues to happen.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dbe6de9 elementor-widget elementor-widget-heading\" data-id=\"dbe6de9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Now when we understand the challenge, let\u2019s deal with it!<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd5fd1a elementor-widget elementor-widget-text-editor\" data-id=\"cd5fd1a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>I am sure that some of you are dealing with this issue often by using manual work (read: retyping each date line by line), but let&#8217;s discover one simple solution you are going to switch to right away.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dd5ca4a elementor-widget elementor-widget-text-editor\" data-id=\"dd5ca4a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>If you have the dot after the date you can just use one simple formula to exclude the dot. For example, if your date with wrong format is in the sel C10, then just apply this simple combination of LEFT and <a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/formulas\/use-len-function-to-provide-data-for-right-function\/\">LEN function<\/a> to get rid of the dot in the end:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-44806549 elementor-widget elementor-widget-text-editor\" data-id=\"44806549\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>=LEFT(C10;LEN(C10)-1)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-120c059 elementor-widget elementor-widget-text-editor\" data-id=\"120c059\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>After that you will be able to use the date which got as a formula result in other functions, such as NETWORKDAYS or WORKDAY function.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-25 elementor-top-column elementor-element elementor-element-4d531054\" data-id=\"4d531054\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>DATA PROCESSING Conversion of dates from text to date format Sometimes it can be hard to deal with text and date formats in Excel. I realized that probably conversion of dates from text to date format issues bother many of you who use Excel daily. So, I hope these insights below will be useful, and [&hellip;]<\/p>","protected":false},"author":1,"featured_media":2469,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"on","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[6],"tags":[],"class_list":["post-880","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-processing","entry","has-media"],"aioseo_notices":[],"rttpg_featured_image_url":{"full":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602.jpeg",1536,865,false],"landscape":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602.jpeg",1536,865,false],"portraits":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602.jpeg",1536,865,false],"thumbnail":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602-150x150.jpeg",150,150,true],"medium":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602-300x169.jpeg",300,169,true],"large":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602-1024x577.jpeg",1024,577,true],"1536x1536":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602.jpeg",1536,865,false],"2048x2048":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602.jpeg",1536,865,false],"trp-custom-language-flag":["https:\/\/www.excelandmacros.com\/wp-content\/uploads\/2021\/09\/dates-conversion-e1760391883602-18x10.jpeg",18,10,true]},"rttpg_author":{"display_name":"adminMilos","author_link":"https:\/\/www.excelandmacros.com\/sr\/magazine\/author\/adminmilos\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/www.excelandmacros.com\/sr\/magazine\/category\/data-processing\/\" rel=\"category tag\">Data Processing<\/a>","rttpg_excerpt":"DATA PROCESSING Conversion of dates from text to date format Sometimes it can be hard to deal with text and date formats in Excel. I realized that probably conversion of dates from text to date format issues bother many of you who use Excel daily. So, I hope these insights below will be useful, and&hellip;","_links":{"self":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/880","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/comments?post=880"}],"version-history":[{"count":12,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/880\/revisions"}],"predecessor-version":[{"id":2472,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/posts\/880\/revisions\/2472"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media\/2469"}],"wp:attachment":[{"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/media?parent=880"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/categories?post=880"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelandmacros.com\/sr\/wp-json\/wp\/v2\/tags?post=880"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}