{"id":439,"date":"2023-10-12T17:00:39","date_gmt":"2023-10-12T17:00:39","guid":{"rendered":"https:\/\/saibam.com.br\/excel\/?p=439"},"modified":"2024-05-04T19:47:58","modified_gmt":"2024-05-04T19:47:58","slug":"funcao-day-em-vba","status":"publish","type":"post","link":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/","title":{"rendered":"Day"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"439\" class=\"elementor elementor-439\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0a99f6f e-flex e-con-boxed e-con e-parent\" data-id=\"0a99f6f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-45ab332 elementor-icon-list--layout-inline elementor-align-center elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"45ab332\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items elementor-inline-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-home\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Home<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/blog\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-blog\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Blog<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/contato\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-contao\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Contato<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/sobre\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"far fa-laugh\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Sobre<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item elementor-inline-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/pesquisar-no-site\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-search\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Pesquisar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f9e9804 e-flex e-con-boxed e-con e-child\" data-id=\"f9e9804\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2dfaff3 elementor-widget elementor-widget-heading\" data-id=\"2dfaff3\" 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\">Fun\u00e7\u00e3o Day em VBA<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2f51315 e-flex e-con-boxed e-con e-parent\" data-id=\"2f51315\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f4fa0a elementor-widget elementor-widget-text-editor\" data-id=\"7f4fa0a\" 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<h2>Descri\u00e7\u00e3o:<\/h2>\n<p>A fun\u00e7\u00e3o <code>Day<\/code> em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.<span style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Para utilizar a fun\u00e7\u00e3o <\/span><code style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Day<\/code><span style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\">, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.<\/span><span style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Por exemplo, ao aplicar a fun\u00e7\u00e3o <\/span><code style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\">Day<\/code><span style=\"font-size: 19px; color: var( --e-global-color-text ); text-align: var(--text-align);\"> na data &#8220;#2023-10-12#&#8221;, o resultado ser\u00e1 o valor &#8220;12&#8221;, que representa o dia correspondente.<\/span><span style=\"color: var( --e-global-color-text ); text-align: var(--text-align);\">Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.<br><\/span><span style=\"font-size: 3.2rem; font-weight: 700; color: var( --e-global-color-text ); text-align: var(--text-align);\">Exemplos:<\/span><\/p>\n<p>Extrair o dia de uma data:<\/p>\n<pre><code>\n    Day(#2023-10-12#)\n    <\/code><\/pre>\n<p><strong>Resultado:<\/strong> Retorna 12.<\/p>\n<p>Extrair o dia de outra data:<\/p>\n<pre><code>\n    Day(#2023-08-25#)\n    <\/code><\/pre>\n<p><strong>Resultado:<\/strong> Retorna 25.<\/p>\n<p>Extrair o dia de uma data vari\u00e1vel:<\/p>\n<pre><code>\n    Dim minhaData As Date\n    minhaData = #2023-05-18#\n    Day(minhaData)\n    <\/code><\/pre>\n<p><strong>Resultado:<\/strong> Retorna 18.<\/p>\n<p>Extrair o dia de uma data e hora:<\/p>\n<pre><code>\n    Day(#2023-10-12 15:30:45#)\n    <\/code><\/pre>\n<p><strong>Resultado:<\/strong> Retorna 12.<\/p>\n<p>Extrair o dia de uma data calculada:<\/p>\n<pre><code>\n    Dim outraData As Date\n    outraData = DateAdd(\"d\", 10, #2023-10-12#)\n    Day(outraData)\n    <\/code><\/pre>\n<p><strong>Resultado:<\/strong> Retorna 22.<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-731515c e-flex e-con-boxed e-con e-parent\" data-id=\"731515c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c340885 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"c340885\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b147a58 e-flex e-con-boxed e-con e-parent\" data-id=\"b147a58\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-cf166ea e-con-full e-flex e-con e-child\" data-id=\"cf166ea\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8a0667e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8a0667e\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-datevalue-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-check\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataValue em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-data-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-times\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Data em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-dataadd-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-dot-circle\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataAdd em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57117f8 e-con-full e-flex e-con e-child\" data-id=\"57117f8\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6305c7b elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"6305c7b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-format-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-flushed\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o Format em VBA - Formatar<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-datepart-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fab fa-wpforms\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataDiff em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/saibam.com.br\/excel\/funcao-dateserial-em-vba\/\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-hand-point-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Fun\u00e7\u00e3o DataSerial em VBA<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-b178054 e-flex e-con-boxed e-con e-parent\" data-id=\"b178054\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3b2791f elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"3b2791f\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Home Blog Contato Sobre Pesquisar Fun\u00e7\u00e3o Day em VBA Descri\u00e7\u00e3o: A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos &hellip; <a href=\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Day<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"tpgb_global_settings":"","footnotes":""},"categories":[125],"tags":[27,30,31,32,34,35,36,38,37,29,28,7,11],"class_list":["post-439","post","type-post","status-publish","format-standard","hentry","category-funcoes-de-datas","tag-conversao-de-texto-para-numero","tag-curdir","tag-data","tag-dateadd","tag-datediff","tag-datepart","tag-dateserial","tag-day","tag-funcao-day","tag-funcao-val","tag-val","tag-vba","tag-visual-basic-for-applications"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Day - Saibam<\/title>\n<meta name=\"description\" content=\"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data &quot;#2023-10-12#&quot;, o resultado ser\u00e1 o valor &quot;12&quot;, que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Day - Saibam\" \/>\n<meta property=\"og:description\" content=\"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data &quot;#2023-10-12#&quot;, o resultado ser\u00e1 o valor &quot;12&quot;, que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Saibam\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-12T17:00:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-04T19:47:58+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\",\"url\":\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\",\"name\":\"Day - Saibam\",\"isPartOf\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\"},\"datePublished\":\"2023-10-12T17:00:39+00:00\",\"dateModified\":\"2024-05-04T19:47:58+00:00\",\"author\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\"},\"description\":\"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data \\\"#2023-10-12#\\\", o resultado ser\u00e1 o valor \\\"12\\\", que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.\",\"breadcrumb\":{\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/saibam.com.br\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Day\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#website\",\"url\":\"https:\/\/saibam.com.br\/excel\/\",\"name\":\"Saibam\",\"description\":\"Excel Macros VBA\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saibam.com.br\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/saibam.com.br\/excel\"],\"url\":\"https:\/\/saibam.com.br\/excel\/author\/admin-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Day - Saibam","description":"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data \"#2023-10-12#\", o resultado ser\u00e1 o valor \"12\", que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.","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:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/","og_locale":"pt_PT","og_type":"article","og_title":"Day - Saibam","og_description":"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data \"#2023-10-12#\", o resultado ser\u00e1 o valor \"12\", que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.","og_url":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/","og_site_name":"Saibam","article_published_time":"2023-10-12T17:00:39+00:00","article_modified_time":"2024-05-04T19:47:58+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/","url":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/","name":"Day - Saibam","isPartOf":{"@id":"https:\/\/saibam.com.br\/excel\/#website"},"datePublished":"2023-10-12T17:00:39+00:00","dateModified":"2024-05-04T19:47:58+00:00","author":{"@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712"},"description":"A fun\u00e7\u00e3o Day em VBA \u00e9 uma ferramenta essencial para trabalhar com datas. Ela permite extrair o componente do dia de uma data espec\u00edfica. Isso \u00e9 especialmente \u00fatil quando precisamos lidar com opera\u00e7\u00f5es que dependem do dia de uma data, como em c\u00e1lculos de prazos ou agendamento de tarefas.Para utilizar a fun\u00e7\u00e3o Day, basta fornecer como argumento a data da qual se deseja extrair o dia. O resultado ser\u00e1 um n\u00famero inteiro representando o dia do m\u00eas.Por exemplo, ao aplicar a fun\u00e7\u00e3o Day na data \"#2023-10-12#\", o resultado ser\u00e1 o valor \"12\", que representa o dia correspondente.Esta fun\u00e7\u00e3o \u00e9 vers\u00e1til e pode ser usada em conjunto com outras fun\u00e7\u00f5es de manipula\u00e7\u00e3o de datas para realizar tarefas mais complexas em VBA.","breadcrumb":{"@id":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/saibam.com.br\/excel\/funcao-day-em-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/saibam.com.br\/excel\/"},{"@type":"ListItem","position":2,"name":"Day"}]},{"@type":"WebSite","@id":"https:\/\/saibam.com.br\/excel\/#website","url":"https:\/\/saibam.com.br\/excel\/","name":"Saibam","description":"Excel Macros VBA","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saibam.com.br\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Person","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/2833a41987f995bb8cbf7e711bdd7712","name":"admin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/saibam.com.br\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/saibam.com.br\/excel"],"url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/"}]}},"tpgb_featured_images":null,"tpgb_post_meta_info":{"get_date":"Outubro 12, 2023","get_modified_date":"Maio 4, 2024","category_list":{"category":[{"term_id":125,"name":"Fun\u00e7\u00f5es de Datas","slug":"funcoes-de-datas","term_group":0,"term_taxonomy_id":125,"taxonomy":"category","description":"","parent":0,"count":6,"filter":"raw"}],"post_tag":[{"term_id":27,"name":"Convers\u00e3o de Texto para N\u00famero","slug":"conversao-de-texto-para-numero","term_group":0,"term_taxonomy_id":27,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":30,"name":"CurDir","slug":"curdir","term_group":0,"term_taxonomy_id":30,"taxonomy":"post_tag","description":"","parent":0,"count":122,"filter":"raw"},{"term_id":31,"name":"data","slug":"data","term_group":0,"term_taxonomy_id":31,"taxonomy":"post_tag","description":"","parent":0,"count":121,"filter":"raw"},{"term_id":32,"name":"dateadd","slug":"dateadd","term_group":0,"term_taxonomy_id":32,"taxonomy":"post_tag","description":"","parent":0,"count":120,"filter":"raw"},{"term_id":34,"name":"datediff","slug":"datediff","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":119,"filter":"raw"},{"term_id":35,"name":"DatePart","slug":"datepart","term_group":0,"term_taxonomy_id":35,"taxonomy":"post_tag","description":"","parent":0,"count":118,"filter":"raw"},{"term_id":36,"name":"dateserial","slug":"dateserial","term_group":0,"term_taxonomy_id":36,"taxonomy":"post_tag","description":"","parent":0,"count":117,"filter":"raw"},{"term_id":38,"name":"day","slug":"day","term_group":0,"term_taxonomy_id":38,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":37,"name":"fun\u00e7\u00e3o day","slug":"funcao-day","term_group":0,"term_taxonomy_id":37,"taxonomy":"post_tag","description":"","parent":0,"count":115,"filter":"raw"},{"term_id":29,"name":"Fun\u00e7\u00e3o Val","slug":"funcao-val","term_group":0,"term_taxonomy_id":29,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":28,"name":"Val","slug":"val","term_group":0,"term_taxonomy_id":28,"taxonomy":"post_tag","description":"","parent":0,"count":123,"filter":"raw"},{"term_id":7,"name":"VBA","slug":"vba","term_group":0,"term_taxonomy_id":7,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"},{"term_id":11,"name":"Visual Basic for Applications","slug":"visual-basic-for-applications","term_group":0,"term_taxonomy_id":11,"taxonomy":"post_tag","description":"","parent":0,"count":129,"filter":"raw"}],"post_format":false},"author_name":"admin","author_url":"https:\/\/saibam.com.br\/excel\/author\/admin-2\/","author_email":"admin@saibam.com.br","author_website":"https:\/\/saibam.com.br\/excel","author_description":"","author_facebook":"","author_twitter":"","author_instagram":"","author_role":["administrator"],"author_firstname":"","author_lastname":"","user_login":"Pizza","author_avatar":"<img alt='' src='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=200&#038;d=mm&#038;r=g' srcset='https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=400&#038;d=mm&#038;r=g 2x' class='avatar avatar-200 photo' height='200' width='200' decoding='async'\/>","author_avatar_url":"https:\/\/secure.gravatar.com\/avatar\/814c3f56d09b0c5755ac3b2c200ae705288694cfce205a77aaa6142979dfe4aa?s=96&d=mm&r=g","comment_count":0,"post_likes":0,"post_views":0},"tpgb_post_category":{"category":"<a href=\"https:\/\/saibam.com.br\/excel\/category\/funcoes-de-datas\/\" alt=\"Fun\u00e7\u00f5es de Datas\" class=\"category-funcoes-de-datas\">Fun\u00e7\u00f5es de Datas<\/a> ","post_tag":"<a href=\"https:\/\/saibam.com.br\/excel\/tag\/conversao-de-texto-para-numero\/\" alt=\"Convers\u00e3o de Texto para N\u00famero\" class=\"post_tag-conversao-de-texto-para-numero\">Convers\u00e3o de Texto para N\u00famero<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/curdir\/\" alt=\"CurDir\" class=\"post_tag-curdir\">CurDir<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/data\/\" alt=\"data\" class=\"post_tag-data\">data<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateadd\/\" alt=\"dateadd\" class=\"post_tag-dateadd\">dateadd<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datediff\/\" alt=\"datediff\" class=\"post_tag-datediff\">datediff<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/datepart\/\" alt=\"DatePart\" class=\"post_tag-datepart\">DatePart<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/dateserial\/\" alt=\"dateserial\" class=\"post_tag-dateserial\">dateserial<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/day\/\" alt=\"day\" class=\"post_tag-day\">day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-day\/\" alt=\"fun\u00e7\u00e3o day\" class=\"post_tag-funcao-day\">fun\u00e7\u00e3o day<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/funcao-val\/\" alt=\"Fun\u00e7\u00e3o Val\" class=\"post_tag-funcao-val\">Fun\u00e7\u00e3o Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/val\/\" alt=\"Val\" class=\"post_tag-val\">Val<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/vba\/\" alt=\"VBA\" class=\"post_tag-vba\">VBA<\/a> <a href=\"https:\/\/saibam.com.br\/excel\/tag\/visual-basic-for-applications\/\" alt=\"Visual Basic for Applications\" class=\"post_tag-visual-basic-for-applications\">Visual Basic for Applications<\/a> "},"_links":{"self":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/439","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/comments?post=439"}],"version-history":[{"count":7,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/439\/revisions"}],"predecessor-version":[{"id":446,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/posts\/439\/revisions\/446"}],"wp:attachment":[{"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/media?parent=439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/categories?post=439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saibam.com.br\/excel\/wp-json\/wp\/v2\/tags?post=439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}