{"id":569,"date":"2023-10-23T05:34:31","date_gmt":"2023-10-23T05:34:31","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/"},"modified":"2023-12-06T11:35:51","modified_gmt":"2023-12-06T11:35:51","slug":"texto-ate-o-momento","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/","title":{"rendered":"Como converter texto em data no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-2217057177\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-3666793798\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p class=\"has-text-align-left\">As datas desempenham um papel importante quando precisamos analisar tend\u00eancias. Esta \u00e9 uma das coisas mais importantes que voc\u00ea precisa capturar da maneira certa. o formato b\u00e1sico de data que o Al\u00e9m do Excel usa para armazenar datas. Existem outros formatos de dados aceit\u00e1veis.<\/p><p> Agora o problema \u00e9: quando capturamos uma data no formato errado, o Excel trata essa data como texto e n\u00e3o podemos mais utilizar essa data em nenhum c\u00e1lculo.<\/p><p> Quando se trata de formatos de dados de texto, n\u00e3o h\u00e1 nada em particular. Depende de quem entra nessas datas. O resultado final \u00e9 este: precisamos de alguns m\u00e9todos que possamos usar para converter algum texto em uma data real com o formato correto.<\/p><p> Ent\u00e3o, hoje neste artigo, gostaria de compartilhar com voc\u00eas 10 m\u00e9todos que podemos usar para converter texto para formato de data no Excel. Para converter qualquer texto em data, precisamos usar uma combina\u00e7\u00e3o de diferentes fun\u00e7\u00f5es.<\/p><p> Ent\u00e3o vamos come\u00e7ar.<\/p><h2 id=\"tab-con-1\" class=\"wp-block-heading\"> 1. Converta o texto at\u00e9 a data<\/h2><p> Usar a fun\u00e7\u00e3o DATEVALUE \u00e9 um m\u00e9todo b\u00e1sico de converter uma data em uma data real armazenada como texto.<\/p><p> Digamos que voc\u00ea tenha uma lista de datas em sua planilha e todas as c\u00e9lulas onde as datas s\u00e3o inseridas tenham formato de texto, mas todas essas datas est\u00e3o no formato de data correto.<\/p><p> No exemplo abaixo temos uma data em uma c\u00e9lula, mas quando tento adicionar um n\u00famero a essa data recebo um erro, mesmo que o formato dos dados esteja correto. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png\" sizes=\"\" srcset=\"\" alt=\"Fun\u00e7\u00e3o datevalue do Excel para converter texto em data\"><\/figure><\/div><p> Mas se voc\u00ea observar o formato da c\u00e9lula, \u00e9 texto. Ent\u00e3o aqui est\u00e1 a melhor maneira de usar a fun\u00e7\u00e3o DATEVALUE. Voc\u00ea s\u00f3 precisa se referir a esta c\u00e9lula na fun\u00e7\u00e3o e ela converter\u00e1 esses dados para a data real. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-le-texte-en-liste-de-dates-avec-la-fonction-datevalue-1.png\" sizes=\"\" srcset=\"\" alt=\"converter texto em lista de datas com a fun\u00e7\u00e3o datevalue\"><\/figure><\/div><p> E ent\u00e3o voc\u00ea pode alterar seu formato at\u00e9 o momento.<\/p><p class=\"qt-tip\"> Nota: Existem algumas situa\u00e7\u00f5es em que DATEVALUE n\u00e3o pode nos ajudar a obter uma data a partir do texto. Existem v\u00e1rios formatos de data irregulares e para lidar com todos os que precisamos, precisamos criar uma f\u00f3rmula personalizada usando diferentes fun\u00e7\u00f5es.<\/p><p> Nos 10 exemplos a seguir, compartilharei com voc\u00eas como usar essas diferentes fun\u00e7\u00f5es. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/liste-texte-a-date-1.png\" sizes=\"\" srcset=\"\" alt=\"listar texto at\u00e9 o momento\"><\/figure><\/div><h2 id=\"tab-con-2\" class=\"wp-block-heading\"> 2. Data com barras invertidas<\/h2><p> O sistema de data do Excel oferece suporte a datas com barras. E, se tivermos uma data com barras invertidas, ela ser\u00e1 tratada como texto. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-le-texte-a-ce-jour-avec-des-barres-noires-invalides-1.png\" sizes=\"\" srcset=\"\" alt=\"converter texto para data com barras pretas inv\u00e1lidas\"><\/figure><\/div><p> Para resolver este problema podemos usar a f\u00f3rmula abaixo. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-le-texte-a-jour-avec-des-barres-noires.png\" sizes=\"\" srcset=\"\" alt=\"converter texto atualizado com barras pretas\"><\/figure><\/div><h2 id=\"tab-con-3\" class=\"wp-block-heading\"> 3. Data com nome do m\u00eas<\/h2><p> Agora temos um formato de data onde o m\u00eas \u00e9 inserido junto com seu nome. Para o Excel, n\u00e3o \u00e9 mais uma data, embora apresente claramente uma data. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-le-texte-en-date-avec-le-nom-du-mois-complet-1.png\" sizes=\"\" srcset=\"\" alt=\"converter texto em data com nome completo do m\u00eas\"><\/figure><\/div><p> A f\u00f3rmula abaixo pode nos ajudar com isso. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(RIGHT(A3,2)&amp;\"-\"&amp;TEXT(MID(A3,6,3),\"MMM\")&amp;\"-\"&amp;LEFT(A3,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/convertir-le-texte-en-date-avec-le-nom-du-mois-complet-1.png\" sizes=\"\" srcset=\"\" alt=\"converter texto em data com f\u00f3rmula de nome completo do m\u00eas\"><\/figure><\/div><h2 id=\"tab-con-4\" class=\"wp-block-heading\"> 4. Data com pontos<\/h2><p> Este \u00e9 um tipo comum de problema onde obtemos pontos dentro de uma data. Este \u00e9 um tipo de formato usado por pessoas que n\u00e3o sabem que n\u00e3o \u00e9 um formato de data adequado. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-convertir-le-texte-a-ce-jour-avec-des-points-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> E esta \u00e9 a f\u00f3rmula para corrigi-lo. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(RIGHT(A4,4),MID(A4,4,2),LEFT(A4,2))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-convertir-le-texte-a-ce-jour-avec-la-formule-de-points-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-5\" class=\"wp-block-heading\"> 5. Data com nome do m\u00eas e v\u00edrgula<\/h2><p> Este formato \u00e9 quase igual ao formato de que falamos no ponto 3. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-convertir-le-texte-a-ce-jour-avec-le-nom-du-mois-long-min.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> E podemos corrigi-lo com a f\u00f3rmula abaixo. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(LEFT(A5,2)&amp;\"-\"&amp;TEXT(MID(A5,4,3),\"MMM\")&amp;\"-\"&amp;RIGHT(A5,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-convertir-le-texte-a-ce-jour-avec-la-formule-de-nom-de-mois-long-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-6\" class=\"wp-block-heading\"> 6. Data com nome do dia<\/h2><p> \u00c0s vezes as pessoas armazenam uma data com o nome do dia. E, se esta data n\u00e3o estiver no formato adequado, o Excel ir\u00e1 trat\u00e1-la como texto. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-convertir-le-texte-a-ce-jour-avec-un-long-nom-de-jour-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Use esta f\u00f3rmula para este tipo de data de texto. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(MID(A6,FIND(\",\",A6)+6,2)&amp;\"-\"&amp;MID(A6,FIND(\",\",A6)+2,3)&amp;\"-\"&amp;RIGHT(A6,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-convertir-le-texte-a-ce-jour-avec-la-formule-de-nom-de-jour-long-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-7\" class=\"wp-block-heading\"> 7. Data com nome de dia no final<\/h2><p> Aqui temos uma data com o nome do dia no final. Agora o problema com este formato \u00e9 que existe uma v\u00edrgula entre a data e o nome do dia. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-convertir-le-texte-en-date-avec-le-nom-du-jour-court-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Por\u00e9m, podemos obter a data v\u00e1lida usando a f\u00f3rmula abaixo. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(MID(A7,10,2)&amp;\"-\"&amp;MID(A7,6,3)&amp;\"-\"&amp;LEFT(A7,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-convertir-le-texte-a-ce-jour-avec-la-formule-de-nom-de-jour-court-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-8\" class=\"wp-block-heading\"> 8. Data com sufixo de dia<\/h2><p> Temos um sufixo \u201cth\u201d com o n\u00famero do dia e isso o torna um texto em vez de uma data porque o Excel n\u00e3o \u00e9 capaz de reconhec\u00ea-lo. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-convertir-le-texte-a-ce-jour-avec-le-suffixe-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> A f\u00f3rmula abaixo o ajudar\u00e1 a obter a data atual. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(LEFT(A8,FIND(\"th\",A8)-1)&amp;\"-\"&amp;MID(A8,FIND(\" \",A8)+1,3)&amp;\"-\"&amp;RIGHT(A8,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-convertir-le-texte-a-ce-jour-avec-la-formule-de-suffixe-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-9\" class=\"wp-block-heading\"> 9. Data com espa\u00e7o entre dia, m\u00eas e ano<\/h2><p> Quando temos um formato de data com espa\u00e7o entre dia, m\u00eas e ano, podemos usar a f\u00f3rmula abaixo para corrigir o formato de data. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-convertir-le-texte-en-date-avec-espace-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(RIGHT(A9,4),MID(A9,4,2),LEFT(A9,2))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-convertir-le-texte-en-date-avec-la-formule-despace-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-10\" class=\"wp-block-heading\"> 10. Data com nome abreviado do m\u00eas<\/h2><p> Com um formato de data onde temos um nome abreviado do m\u00eas no in\u00edcio da data. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-convertir-le-texte-en-date-avec-lespace-de-nom-du-mois-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> Podemos usar a seguinte f\u00f3rmula para convert\u00ea-lo em um formato de data v\u00e1lido. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATEVALUE(MID(A10,5,2)&amp;\"-\"&amp;LEFT(A10,3)&amp;\"-\"&amp;RIGHT(A10,4))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-convertir-le-texte-en-date-avec-la-formule-despace-de-nom-de-mois-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><h2 id=\"tab-con-11\" class=\"wp-block-heading\"> 11. Data sem espa\u00e7o entre dia, m\u00eas e ano<\/h2><p> E para uma data onde n\u00e3o h\u00e1 espa\u00e7o entre dia, m\u00eas e ano. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-convertir-le-texte-a-ce-jour-sans-espace-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><p> A f\u00f3rmula abaixo nos ajudar\u00e1 a obter o formato de data correto. <\/p><pre class=\"wp-block-code\"> <code class=\"language-excel-formula\" lang=\"excel-formula\">=DATE(RIGHT(A11,2),MID(A11,3,2),LEFT(A11,2))<\/code><\/pre><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-convertir-le-texte-a-ce-jour-sans-formule-despace-min-1.png\" sizes=\"\" srcset=\"\" alt=\"\"><\/figure><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/formulas\/\">Lista de f\u00f3rmulas do Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/destacando-entre-duas-datas\/\">Destacar datas entre duas datas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/concatenar-duas-datas\/\">Concatene rapidamente duas datas no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/gerador-de-data-aleatoria\/\">Gerador de data aleat\u00f3ria (f\u00f3rmula Excel) no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/combinar-data-e-hora\/\">Combine data e hora no Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-569","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Como converter texto em data no Excel? (7 exemplos)<\/title>\n<meta name=\"description\" content=\"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Como converter texto em data no Excel? (7 exemplos)\" \/>\n<meta property=\"og:description\" content=\"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:35:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/\",\"name\":\"Como converter texto em data no Excel? (7 exemplos)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png\",\"datePublished\":\"2023-10-23T05:34:31+00:00\",\"dateModified\":\"2023-12-06T11:35:51+00:00\",\"description\":\"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como converter texto em data no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Como converter texto em data no Excel? (7 exemplos)","description":"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.","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:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/","og_locale":"pt_PT","og_type":"article","og_title":"Como converter texto em data no Excel? (7 exemplos)","og_description":"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.","og_url":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:35:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/","url":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/","name":"Como converter texto em data no Excel? (7 exemplos)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png","datePublished":"2023-10-23T05:34:31+00:00","dateModified":"2023-12-06T11:35:51+00:00","description":"\u00c9 importante ter as datas no formato correto. Ent\u00e3o, aprenda como converter texto em data no Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Fonction-Excel-DateValue-pour-convertir-une-date-textuelle-en-date-valide-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/texto-ate-o-momento\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como converter texto em data no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=569"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/569\/revisions"}],"predecessor-version":[{"id":942,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/569\/revisions\/942"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}