{"id":2870,"date":"2021-04-27T10:52:34","date_gmt":"2021-04-27T10:52:34","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2870"},"modified":"2021-07-23T11:55:09","modified_gmt":"2021-07-23T11:55:09","slug":"criar-calendario-no-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel","title":{"rendered":"3 maneiras Para Criar Calend\u00e1rio No Excel"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<blockquote>\n<p style=\"text-align: justify;\"><strong>Resumo <\/strong>:<\/p>\n<p style=\"text-align: justify;\">O tutorial explica\u00a0<strong>como criar um calend\u00e1rio no Excel\u00a0<\/strong>com etapas completas.\u00a0Al\u00e9m disso, voc\u00ea tamb\u00e9m aprender\u00e1 truques para\u00a0<strong>criar calend\u00e1rio a partir de dados de planilhas do Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o, sem perder mais tempo, vamos mergulhar neste post\u2026.!<!--more--><\/p>\n<\/blockquote>\n<h2 style=\"text-align: justify;\"><strong><u>Como\u00a0Para\u00a0Criar Calend\u00e1rio No Excel?<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Se voc\u00ea deseja manter seus dados de forma mais organizada, um sistema de calend\u00e1rio adequado \u00e9 muito importante para o gerenciamento correto do tempo.\u00a0Felizmente, o Excel oferece diferentes maneiras de criar calend\u00e1rios.\u00a0Vamos conhecer cada um deles em detalhes.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 1: Criar calend\u00e1rio\u00a0no\u00a0Excel usando o controle de sele\u00e7\u00e3o de data<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Para\u00a0<strong>criar um calend\u00e1rio no Excel, \u00e9\u00a0<\/strong>necess\u00e1rio inserir um calend\u00e1rio.\u00a0Bem, colocar o calend\u00e1rio suspenso no Excel \u00e9 muito f\u00e1cil de fazer, mas s\u00f3 porque o controle do seletor de hora e data est\u00e1 oculto, muitos usu\u00e1rios n\u00e3o sabem onde ele realmente existe.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e1 o\u00a0<strong>m\u00e9todo\u00a0<\/strong>completo\u00a0<strong>para criar um calend\u00e1rio no Excel e\u00a0<\/strong>realizar\u00a0esta tarefa passo a passo:<\/p>\n<p style=\"text-align: justify;\"><strong>Nota: <\/strong>O\u00a0controle de selecionador de data da Microsoft funciona muito bem com o da Microsoft nas\u00a0vers\u00f5es\u00a0do Excel de\u00a0<strong>32 bits,\u00a0<\/strong>mas n\u00e3o na vers\u00e3o do Excel de 64 bits.<\/p>\n<ol style=\"text-align: justify;\">\n<li><strong><u>Ative a guia Desenvolvedor na faixa de op\u00e7\u00f5es do Excel.<\/u><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">O\u00a0<strong>controle de seletor de data do\u00a0<\/strong>Excel\u00a0realmente pertence \u00e0 fam\u00edlia de controles ActiveX, que vem na\u00a0guia\u00a0Desenvolvedor\u00a0.\u00a0Embora esta guia Desenvolvedor do Excel seja mantida oculta, voc\u00ea pode habilitar sua visibilidade.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Na ribbon do Excel, deve-se clicar com o bot\u00e3o direito do mouse, depois escolher a op\u00e7\u00e3o\u00a0Customize the Ribbon\u00a0\u2026.\u00a0Isso abrir\u00e1 as\u00a0op\u00e7\u00f5es\u00a0do<\/li>\n<li>Da janela aberta, v\u00e1 para a se\u00e7\u00e3o do lado direito.\u00a0Agora, depois de personalizar a se\u00e7\u00e3o da faixa de op\u00e7\u00f5es, voc\u00ea deve selecionar as\u00a0guias principais\u00a0.\u00a0Na\u00a0lista da\u00a0guia principal\u00a0exibida,\u00a0marque a\u00a0op\u00e7\u00e3o da\u00a0caixa Desenvolvedor\u00a0e clique\u00a0no\u00a0bot\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2872\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-1.png\" alt=\"1\" width=\"610\" height=\"491\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-1.png 610w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-1-300x241.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li><strong><u>Insira o controle do calend\u00e1rio<\/u><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Bem, o calend\u00e1rio suspenso do Excel \u00e9 tecnicamente conhecido como Controle de seletor de data e hora da Microsoft.<\/p>\n<p style=\"text-align: justify;\">Para aplicar isso na planilha do Excel, execute as seguintes etapas:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Acesse a\u00a0guia Desenvolvedor\u00a0e, em seguida, no\u00a0grupo\u00a0Controles\u00a0, voc\u00ea deve tocar no sinal de seta presente na\u00a0guia\u00a0Inserir\u00a0.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Agora, nos\u00a0controles ActiveX,\u00a0escolha o\u00a0bot\u00e3o\u00a0\u201cMais controles\u201d\u00a0.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2873\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-2.png\" alt=\"2\" width=\"322\" height=\"315\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-2.png 322w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-2-300x293.png 300w\" sizes=\"auto, (max-width: 322px) 100vw, 322px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na caixa de di\u00e1logo aberta de Mais controles, selecione o Microsoft Date and Time Picker Control 6.0 (SP6) . Depois disso, clique em OK.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2874\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-3.png\" alt=\"3\" width=\"366\" height=\"323\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-3.png 366w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-3-300x265.png 300w\" sizes=\"auto, (max-width: 366px) 100vw, 366px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Bata na c\u00e9lula, na qual voc\u00ea tem que entrar no controle do calend\u00e1rio.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Voc\u00ea ver\u00e1 que um controle de calend\u00e1rio suspenso come\u00e7a a aparecer em sua planilha do Excel:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2875\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-4.png\" alt=\"4\" width=\"402\" height=\"192\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-4.png 402w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-4-300x143.png 300w\" sizes=\"auto, (max-width: 402px) 100vw, 402px\" \/><\/p>\n<p style=\"text-align: justify;\">Depois que esse controle selecionador de data for inserido, voc\u00ea ver\u00e1 que a f\u00f3rmula EMBED come\u00e7a a aparecer na barra de f\u00f3rmulas.<\/p>\n<p style=\"text-align: justify;\">Isso fornece detalhes ao seu aplicativo Excel sobre o tipo de controle incorporado na planilha.\u00a0Voc\u00ea n\u00e3o pode alterar, editar ou excluir este controle porque isso mostrar\u00e1 o erro\u00a0<strong>&#8220;<\/strong><a href=\"https:\/\/pt.repairmsexcel.com\/blog\/resolver-excel-dados-fonte-referencia-is-nao-valido-erro\" target=\"_blank\" rel=\"noopener\"><strong>refer\u00eancia n\u00e3o \u00e9 v\u00e1lida<\/strong><\/a><strong>&#8220;.<\/strong><\/p>\n<p style=\"text-align: justify;\">Adicionar o controle ActiveX a tal selecionador de data ativa automaticamente o modo de design que permitir\u00e1 a voc\u00ea alterar as propriedades e a apar\u00eancia de qualquer controle rec\u00e9m-adicionado.\u00a0As modifica\u00e7\u00f5es mais \u00f3bvias que voc\u00ea precisa fazer neste momento \u00e9 redimensionar o controle do calend\u00e1rio e, em seguida, vincul\u00e1-lo de volta a qualquer c\u00e9lula espec\u00edfica.<\/p>\n<p style=\"text-align: justify;\">Para\u00a0ativar\u00a0a op\u00e7\u00e3o de calend\u00e1rio suspenso do Excel, acesse a\u00a0guia\u00a0Design\u00a0e, a partir do\u00a0grupo\u00a0Controles\u00a0, desative o\u00a0Modo Design\u00a0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2876\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-5.png\" alt=\"5\" width=\"229\" height=\"127\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, toque na seta suspensa para exibir o calend\u00e1rio e selecione a data de acordo com sua necessidade.<\/li>\n<li>Clique na seta suspensa para mostrar o calend\u00e1rio no Excel e escolha a data desejada.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2877\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-6.png\" alt=\"6\" width=\"200\" height=\"198\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-6.png 200w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-6-150x150.png 150w\" sizes=\"auto, (max-width: 200px) 100vw, 200px\" \/><\/p>\n<p style=\"text-align: justify;\"><strong>Observa\u00e7\u00e3o:<\/strong><\/p>\n<p style=\"text-align: justify;\">Se o seletor de data MS, o controle n\u00e3o estiver dispon\u00edvel na\u00a0lista de\u00a0Mais controles\u00a0.\u00a0Esta situa\u00e7\u00e3o surge principalmente pelas seguintes raz\u00f5es.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Enquanto voc\u00ea estiver executando a vers\u00e3o de 64 bits do MS Office.\u00a0Como n\u00e3o h\u00e1 um controle selecionador de data oficial dispon\u00edvel no\u00a0Office de\u00a064 bits.<\/li>\n<li>O controle de calend\u00e1rio,\u00a0ou seja,\u00a0mscomct2.ocx agora n\u00e3o est\u00e1 presente ou n\u00e3o est\u00e1 registrado no seu PC.<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li><strong><u>Personalize o controle da agenda<\/u><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Ap\u00f3s a adi\u00e7\u00e3o do controle de calend\u00e1rio em sua planilha do Excel, agora voc\u00ea precisa deslocar esse controle de calend\u00e1rio para o local desejado e redimension\u00e1-lo para caber facilmente em uma c\u00e9lula.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Para redimensionar este controle selecionador de data, voc\u00ea deve habilitar o\u00a0Modo de Design e, em\u00a0seguida, arrastar este controle da se\u00e7\u00e3o do canto:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2878\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-7.png\" alt=\"7\" width=\"323\" height=\"82\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-7.png 323w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-7-300x76.png 300w\" sizes=\"auto, (max-width: 323px) 100vw, 323px\" \/><\/p>\n<p style=\"text-align: justify;\">Ou ent\u00e3o, ap\u00f3s ativar o\u00a0Modo\u00a0Design\u00a0, no grupo de controle de calend\u00e1rio, escolha a\u00a0guia Propriedades\u00a0:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2879\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-8.png\" alt=\"8\" width=\"451\" height=\"281\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-8.png 451w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-8-300x187.png 300w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na\u00a0janela\u00a0Propriedades\u00a0aberta\u00a0, voc\u00ea deve definir a\u00a0largura\u00a0,\u00a0altura\u00a0,\u00a0tamanho da fonte e estilo\u00a0desejados\u00a0:<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2880\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-9.png\" alt=\"9\" width=\"390\" height=\"588\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-9.png 390w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-9-199x300.png 199w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Para\u00a0mudar\u00a0o controle do seletor de data do Excel, coloque o ponteiro do mouse sobre ele e quando o cursor mudar para um sinal de seta de quatro pontas, arraste o objeto para onde quiser.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2881\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-10.png\" alt=\"10\" width=\"381\" height=\"135\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-10.png 381w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-10-300x106.png 300w\" sizes=\"auto, (max-width: 381px) 100vw, 381px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li><strong><u>Vincule o controle do calend\u00e1rio do Excel \u00e0 c\u00e9lula<\/u><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Depois de adicionar com sucesso o menu suspenso de calend\u00e1rio no Excel, voc\u00ea precisa vincul\u00e1-lo a alguma c\u00e9lula espec\u00edfica.\u00a0Esta etapa \u00e9 muito obrigat\u00f3ria se voc\u00ea quiser fazer uso de quaisquer datas selecionadas com as f\u00f3rmulas.<\/p>\n<p style=\"text-align: justify;\">Suponha que voc\u00ea esteja escrevendo a f\u00f3rmula para contar o n\u00famero do pedido entre quaisquer datas espec\u00edficas.\u00a0Para impedir que qualquer outro insira datas erradas, como 30\/02\/2016, voc\u00ea inseriu um calend\u00e1rio suspenso dentro de 2 c\u00e9lulas.<\/p>\n<p style=\"text-align: justify;\">A\u00a0f\u00f3rmula\u00a0CONT.SE\u00a0que voc\u00ea aplicou para calcular um n\u00famero de pedidos retornar\u00e1 o valor \u201c0\u201d mesmo se os pedidos estiverem presentes.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2882\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-11.png\" alt=\"11\" width=\"320\" height=\"222\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-11.png 320w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-11-300x208.png 300w\" sizes=\"auto, (max-width: 320px) 100vw, 320px\" \/><\/p>\n<p style=\"text-align: justify;\">Bem, o principal motivo pode ser que seu Excel n\u00e3o \u00e9 capaz de reconhecer o valor presente no controle do selecionador de data.\u00a0Esse problema persistir\u00e1 at\u00e9 que voc\u00ea vincule o controle a alguma c\u00e9lula espec\u00edfica.\u00a0Esta \u00e9 a etapa que voc\u00ea precisa executar:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Selecionando o\u00a0controle de calend\u00e1rio,\u00a0voc\u00ea deve habilitar o\u00a0Modo Design\u00a0.<\/li>\n<li>V\u00e1 para a\u00a0guia Desenvolvedor\u00a0e, a partir do\u00a0grupo de controle,\u00a0toque no<\/li>\n<li>Nas\u00a0janelas\u00a0\u201cPropriedades\u00a0\u201d\u00a0abertas\u00a0, atribua a refer\u00eancia de c\u00e9lula na\u00a0propriedade\u00a0LinkedCell\u00a0(aqui eu escrevi A3):<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2883\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-12.png\" alt=\"12\" width=\"390\" height=\"588\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-12.png 390w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-12-199x300.png 199w\" sizes=\"auto, (max-width: 390px) 100vw, 390px\" \/><\/p>\n<p style=\"text-align: justify;\">Se o Excel mostrar o seguinte erro\u00a0&#8221;\u00a0N\u00e3o \u00e9 poss\u00edvel definir o valor da c\u00e9lula como NULL\u2026&#8221;\u00a0, clique no\u00a0bot\u00e3o\u00a0OK\u00a0para ignorar isso.<\/p>\n<p style=\"text-align: justify;\">Depois de selecionar a data no calend\u00e1rio suspenso, a data come\u00e7ar\u00e1 a aparecer imediatamente na c\u00e9lula vinculada.\u00a0Agora o Excel n\u00e3o enfrentar\u00e1 nenhum problema em entender as datas e a f\u00f3rmula de refer\u00eancia feita nas c\u00e9lulas vinculadas funcionar\u00e1 perfeitamente.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2884\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-13.png\" alt=\"13\" width=\"418\" height=\"235\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-13.png 418w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-13-300x169.png 300w\" sizes=\"auto, (max-width: 418px) 100vw, 418px\" \/><\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea n\u00e3o precisa ter datas extras, vincule o controle do seletor de data \u00e0s c\u00e9lulas onde est\u00e3o presentes.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>M\u00e9todo 2: usando o modelo de calend\u00e1rio do Excel<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Nesta se\u00e7\u00e3o, discutiremos particularmente\u00a0<strong>como criar um calend\u00e1rio a partir de\u00a0dados de\u00a0planilhas\u00a0do Excel\u00a0.<\/strong><\/p>\n<p style=\"text-align: justify;\">No Excel, existem op\u00e7\u00f5es gr\u00e1ficas \u00fateis com clipart, tabelas, ferramentas de desenho, gr\u00e1ficos, etc. Usando essas op\u00e7\u00f5es, \u00e9 poss\u00edvel criar facilmente um calend\u00e1rio mensal ou semanal com datas ou fotos de ocasi\u00f5es especiais.<\/p>\n<p style=\"text-align: justify;\">Ent\u00e3o v\u00e1 com o\u00a0<strong>modelo de calend\u00e1rio\u00a0<\/strong>do\u00a0<strong>Excel,\u00a0<\/strong>que \u00e9 a maneira mais r\u00e1pida e f\u00e1cil de\u00a0<strong>criar um calend\u00e1rio no Excel usando dados de planilha.<\/strong><\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as etapas para\u00a0<strong>criar um calend\u00e1rio a partir dos\u00a0dados da\u00a0planilha\u00a0do Excel\u00a0<\/strong>usando o modelo.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique em\u00a0Arquivo\u00a0&gt;\u00a0Novo e, em\u00a0seguida, na caixa de pesquisa, digite\u00a0&#8220;calend\u00e1rio&#8221;.<\/li>\n<li>O Excel far\u00e1 pesquisas em milhares de modelos online e, em seguida, mostrar\u00e1 os modelos de calend\u00e1rio selecionados, agrupados nas seguintes categorias.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2885\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-14.png\" alt=\"14\" width=\"621\" height=\"699\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-14.png 621w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-14-267x300.png 267w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Escolha o\u00a0modelo de calend\u00e1rio de\u00a0acordo com sua necessidade e, em seguida, toque em<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2886\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-15.png\" alt=\"15\" width=\"584\" height=\"513\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-15.png 584w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-15-300x264.png 300w\" sizes=\"auto, (max-width: 584px) 100vw, 584px\" \/><\/p>\n<p style=\"text-align: justify;\">Isso \u00e9 tudo que voc\u00ea precisa fazer &#8230;!<\/p>\n<p style=\"text-align: justify;\">O modelo de calend\u00e1rio do Excel ser\u00e1 aberto na nova pasta de trabalho do Excel e, em seguida, ser\u00e1 impresso ou personalizado de acordo com sua necessidade.\u00a0Normalmente, os modelos de calend\u00e1rio do Excel s\u00e3o definidos com um ano, enquanto em alguns modelos voc\u00ea pode definir um dia para o in\u00edcio da semana.<\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o: para exibir sempre o ano atual em seu calend\u00e1rio do Excel, atribua uma f\u00f3rmula simples como esta na c\u00e9lula do ano:\u00a0=\u00a0ANO (\u00a0TODAY ())<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2887\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-16.png\" alt=\"16\" width=\"590\" height=\"348\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-16.png 590w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/create-calendar-in-excel-16-300x177.png 300w\" sizes=\"auto, (max-width: 590px) 100vw, 590px\" \/><\/p>\n<p style=\"text-align: justify;\">Dessa forma, voc\u00ea pode inserir facilmente o calend\u00e1rio suspenso.\u00a0Al\u00e9m disso, voc\u00ea pode fazer um calend\u00e1rio do Excel para impress\u00e3o.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 3: Criar calend\u00e1rio\u00a0no\u00a0Excel usando c\u00f3digo VBA<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Neste m\u00e9todo, voc\u00ea aprender\u00e1 como usar o c\u00f3digo de macro do Visual Basic for Applications (VBA) para\u00a0<strong>criar um calend\u00e1rio no Excel.<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Abra sua pasta de trabalho do Excel.<\/li>\n<li>Para usu\u00e1rios do Excel 2003: V\u00e1 ao\u00a0menu Ferramentas\u00a0e, em seguida, clique na\u00a0guia Macro.\u00a0Depois disso, escolha o\u00a0Editor\u00a0do\u00a0Visual Basic\u00a0.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Para usu\u00e1rios do Excel 2007 ou posterior: v\u00e1 para a\u00a0guia\u00a0Desenvolvedor\u00a0na faixa do Excel e escolha\u00a0Visual Basic\u00a0.<\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>No\u00a0menu Inserir\u00a0, escolha a\u00a0op\u00e7\u00e3o\u00a0M\u00f3dulo\u00a0.<\/li>\n<li>Agora cole o\u00a0c\u00f3digo VBA\u00a0que \u00e9 fornecido abaixo na folha aberta do m\u00f3dulo.<\/li>\n<li>V\u00e1 para o\u00a0menu Arquivo\u00a0e escolha\u00a0Fechar e Retornar ao Microsoft Excel\u00a0.<\/li>\n<li>Agora fa\u00e7a uma sele\u00e7\u00e3o da\u00a0Folha1<\/li>\n<li>No\u00a0menu Ferramentas\u00a0, v\u00e1 para a\u00a0guia\u00a0Macro\u00a0.\u00a0Depois disso, escolha o\u00a0\u00edcone\u00a0Macros\u00a0.<\/li>\n<li>Agora voc\u00ea tem que escolher o\u00a0Agora pressione o\u00a0bot\u00e3o Executar\u00a0para\u00a0<strong>criar o calend\u00e1rio do Excel.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong><u>Procedimento do Visual Basic\u00a0para\u00a0criar um calend\u00e1rio no Excel:<\/u><\/strong><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea deve colar este c\u00f3digo na planilha do m\u00f3dulo.<\/p>\n<blockquote><p>Sub CalendarMaker()<\/p>\n<p>&#8216; Unprotect sheet if had previous calendar to prevent error.<br \/>\nActiveSheet.Protect DrawingObjects:=False, Contents:=False, _<br \/>\nScenarios:=False<br \/>\n&#8216; Prevent screen flashing while drawing calendar.<br \/>\nApplication.ScreenUpdating = False<br \/>\n&#8216; Set up error trapping.<br \/>\nOn Error GoTo MyErrorTrap<br \/>\n&#8216; Clear area a1:g14 including any previous calendar.<br \/>\nRange(&#8220;a1:g14&#8221;).Clear<br \/>\n&#8216; Use InputBox to get desired month and year and set variable<br \/>\n&#8216; MyInput.<br \/>\nMyInput = InputBox(&#8220;Type in Month and year for Calendar &#8220;)<br \/>\n&#8216; Allow user to end macro with Cancel in InputBox.<br \/>\nIf MyInput = &#8220;&#8221; Then Exit Sub<br \/>\n&#8216; Get the date value of the beginning of inputted month.<br \/>\nStartDay = DateValue(MyInput)<br \/>\n&#8216; Check if valid date but not the first of the month<br \/>\n&#8216; &#8212; if so, reset StartDay to first day of month.<br \/>\nIf Day(StartDay) &lt;&gt; 1 Then<br \/>\nStartDay = DateValue(Month(StartDay) &amp; &#8220;\/1\/&#8221; &amp; _<br \/>\nYear(StartDay))<br \/>\nEnd If<br \/>\n&#8216; Prepare cell for Month and Year as fully spelled out.<br \/>\nRange(&#8220;a1&#8221;).NumberFormat = &#8220;mmmm yyyy&#8221;<br \/>\n&#8216; Center the Month and Year label across a1:g1 with appropriate<br \/>\n&#8216; size, height and bolding.<br \/>\nWith Range(&#8220;a1:g1&#8221;)<br \/>\n.HorizontalAlignment = xlCenterAcrossSelection<br \/>\n.VerticalAlignment = xlCenter<br \/>\n.Font.Size = 18<br \/>\n.Font.Bold = True<br \/>\n.RowHeight = 35<br \/>\nEnd With<br \/>\n&#8216; Prepare a2:g2 for day of week labels with centering, size,<br \/>\n&#8216; height and bolding.<br \/>\nWith Range(&#8220;a2:g2&#8221;)<br \/>\n.ColumnWidth = 11<br \/>\n.VerticalAlignment = xlCenter<br \/>\n.HorizontalAlignment = xlCenter<br \/>\n.VerticalAlignment = xlCenter<br \/>\n.Orientation = xlHorizontal<br \/>\n.Font.Size = 12<br \/>\n.Font.Bold = True<br \/>\n.RowHeight = 20<br \/>\nEnd With<br \/>\n&#8216; Put days of week in a2:g2.<br \/>\nRange(&#8220;a2&#8221;) = &#8220;Sunday&#8221;<br \/>\nRange(&#8220;b2&#8221;) = &#8220;Monday&#8221;<br \/>\nRange(&#8220;c2&#8221;) = &#8220;Tuesday&#8221;<br \/>\nRange(&#8220;d2&#8221;) = &#8220;Wednesday&#8221;<br \/>\nRange(&#8220;e2&#8221;) = &#8220;Thursday&#8221;<br \/>\nRange(&#8220;f2&#8221;) = &#8220;Friday&#8221;<br \/>\nRange(&#8220;g2&#8221;) = &#8220;Saturday&#8221;<br \/>\n&#8216; Prepare a3:g7 for dates with left\/top alignment, size, height<br \/>\n&#8216; and bolding.<br \/>\nWith Range(&#8220;a3:g8&#8221;)<br \/>\n.HorizontalAlignment = xlRight<br \/>\n.VerticalAlignment = xlTop<br \/>\n.Font.Size = 18<br \/>\n.Font.Bold = True<br \/>\n.RowHeight = 21<br \/>\nEnd With<br \/>\n&#8216; Put inputted month and year fully spelling out into &#8220;a1&#8221;.<br \/>\nRange(&#8220;a1&#8221;).Value = Application.Text(MyInput, &#8220;mmmm yyyy&#8221;)<br \/>\n&#8216; Set variable and get which day of the week the month starts.<br \/>\nDayofWeek = WeekDay(StartDay)<br \/>\n&#8216; Set variables to identify the year and month as separate<br \/>\n&#8216; variables.<br \/>\nCurYear = Year(StartDay)<br \/>\nCurMonth = Month(StartDay)<br \/>\n&#8216; Set variable and calculate the first day of the next month.<br \/>\nFinalDay = DateSerial(CurYear, CurMonth + 1, 1)<br \/>\n&#8216; Place a &#8220;1&#8221; in cell position of the first day of the chosen<br \/>\n&#8216; month based on DayofWeek.<br \/>\nSelect Case DayofWeek<br \/>\nCase 1<br \/>\nRange(&#8220;a3&#8221;).Value = 1<br \/>\nCase 2<br \/>\nRange(&#8220;b3&#8221;).Value = 1<br \/>\nCase 3<br \/>\nRange(&#8220;c3&#8221;).Value = 1<br \/>\nCase 4<br \/>\nRange(&#8220;d3&#8221;).Value = 1<br \/>\nCase 5<br \/>\nRange(&#8220;e3&#8221;).Value = 1<br \/>\nCase 6<br \/>\nRange(&#8220;f3&#8221;).Value = 1<br \/>\nCase 7<br \/>\nRange(&#8220;g3&#8221;).Value = 1<br \/>\nEnd Select<br \/>\n&#8216; Loop through range a3:g8 incrementing each cell after the &#8220;1&#8221;<br \/>\n&#8216; cell.<br \/>\nFor Each cell In Range(&#8220;a3:g8&#8221;)<br \/>\nRowCell = cell.Row<br \/>\nColCell = cell.Column<br \/>\n&#8216; Do if &#8220;1&#8221; is in first column.<br \/>\nIf cell.Column = 1 And cell.Row = 3 Then<br \/>\n&#8216; Do if current cell is not in 1st column.<br \/>\nElseIf cell.Column &lt;&gt; 1 Then<br \/>\nIf cell.Offset(0, -1).Value &gt;= 1 Then<br \/>\ncell.Value = cell.Offset(0, -1).Value + 1<br \/>\n&#8216; Stop when the last day of the month has been<br \/>\n&#8216; entered.<br \/>\nIf cell.Value &gt; (FinalDay &#8211; StartDay) Then<br \/>\ncell.Value = &#8220;&#8221;<br \/>\n&#8216; Exit loop when calendar has correct number of<br \/>\n&#8216; days shown.<br \/>\nExit For<br \/>\nEnd If<br \/>\nEnd If<br \/>\n&#8216; Do only if current cell is not in Row 3 and is in Column 1.<br \/>\nElseIf cell.Row &gt; 3 And cell.Column = 1 Then<br \/>\ncell.Value = cell.Offset(-1, 6).Value + 1<br \/>\n&#8216; Stop when the last day of the month has been entered.<br \/>\nIf cell.Value &gt; (FinalDay &#8211; StartDay) Then<br \/>\ncell.Value = &#8220;&#8221;<br \/>\n&#8216; Exit loop when calendar has correct number of days<br \/>\n&#8216; shown.<br \/>\nExit For<br \/>\nEnd If<br \/>\nEnd If<br \/>\nNext<\/p>\n<p>&#8216; Create Entry cells, format them centered, wrap text, and border<br \/>\n&#8216; around days.<br \/>\nFor x = 0 To 5<br \/>\nRange(&#8220;A4&#8221;).Offset(x * 2, 0).EntireRow.Insert<br \/>\nWith Range(&#8220;A4:G4&#8221;).Offset(x * 2, 0)<br \/>\n.RowHeight = 65<br \/>\n.HorizontalAlignment = xlCenter<br \/>\n.VerticalAlignment = xlTop<br \/>\n.WrapText = True<br \/>\n.Font.Size = 10<br \/>\n.Font.Bold = False<br \/>\n&#8216; Unlock these cells to be able to enter text later after<br \/>\n&#8216; sheet is protected.<br \/>\n.Locked = False<br \/>\nEnd With<br \/>\n&#8216; Put border around the block of dates.<br \/>\nWith Range(&#8220;A3&#8221;).Offset(x * 2, 0).Resize(2, _<br \/>\n7).Borders(xlLeft)<br \/>\n.Weight = xlThick<br \/>\n.ColorIndex = xlAutomatic<br \/>\nEnd With<\/p>\n<p>With Range(&#8220;A3&#8221;).Offset(x * 2, 0).Resize(2, _<br \/>\n7).Borders(xlRight)<br \/>\n.Weight = xlThick<br \/>\n.ColorIndex = xlAutomatic<br \/>\nEnd With<br \/>\nRange(&#8220;A3&#8221;).Offset(x * 2, 0).Resize(2, 7).BorderAround _<br \/>\nWeight:=xlThick, ColorIndex:=xlAutomatic<br \/>\nNext<br \/>\nIf Range(&#8220;A13&#8221;).Value = &#8220;&#8221; Then Range(&#8220;A13&#8221;).Offset(0, 0) _<br \/>\n.Resize(2, 8).EntireRow.Delete<br \/>\n&#8216; Turn off gridlines.<br \/>\nActiveWindow.DisplayGridlines = False<br \/>\n&#8216; Protect sheet to prevent overwriting the dates.<br \/>\nActiveSheet.Protect DrawingObjects:=True, Contents:=True, _<br \/>\nScenarios:=True<\/p>\n<p>&#8216; Resize window to show all of calendar (may have to be adjusted<br \/>\n&#8216; for video configuration).<br \/>\nActiveWindow.WindowState = xlMaximized<br \/>\nActiveWindow.ScrollRow = 1<\/p>\n<p>&#8216; Allow screen to redraw with calendar showing.<br \/>\nApplication.ScreenUpdating = True<br \/>\n&#8216; Prevent going to error trap unless error found by exiting Sub<br \/>\n&#8216; here.<br \/>\nExit Sub<br \/>\n&#8216; Error causes msgbox to indicate the problem, provides new input box,<br \/>\n&#8216; and resumes at the line that caused the error.<br \/>\nMyErrorTrap:<br \/>\nMsgBox &#8220;You may not have entered your Month and Year correctly.&#8221; _<br \/>\n&amp; Chr(13) &amp; &#8220;Spell the Month correctly&#8221; _<br \/>\n&amp; &#8221; (or use 3 letter abbreviation)&#8221; _<br \/>\n&amp; Chr(13) &amp; &#8220;and 4 digits for the Year&#8221;<br \/>\nMyInput = InputBox(&#8220;Type in Month and year for Calendar&#8221;)<br \/>\nIf MyInput = &#8220;&#8221; Then Exit Sub<br \/>\nResume<br \/>\nEnd Sub<\/p><\/blockquote>\n<p style=\"text-align: justify;\">Nota: Voc\u00ea pode personalizar o c\u00f3digo acima de acordo com sua necessidade.<\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Embrulhar:<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">O MS Excel oferece ao seu usu\u00e1rio uma ampla gama de ferramentas que ir\u00e3o aumentar sua produtividade por meio dos projetos, datas e eventos de rastreamento.\u00a0Para visualizar os dados da sua planilha Excel em formato de calend\u00e1rio, a Microsoft ir\u00e1 alterar seus dados e, em seguida, import\u00e1-los para o Outlook.\u00a0Isso o mudar\u00e1 automaticamente para um formato de calend\u00e1rio.<\/p>\n<p style=\"text-align: justify;\">Felizmente, voc\u00ea deve ter encontrado a ampla quantidade de informa\u00e7\u00f5es neste post.\u00a0Obrigado por ler este post\u2026.!<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Resumo : O tutorial explica\u00a0como criar um calend\u00e1rio no Excel\u00a0com etapas completas.\u00a0Al\u00e9m disso, voc\u00ea tamb\u00e9m aprender\u00e1 truques para\u00a0criar calend\u00e1rio a &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"3 maneiras Para Criar Calend\u00e1rio No Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#more-2870\" aria-label=\"Read more about 3 maneiras Para Criar Calend\u00e1rio No Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":2954,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[1144,1141,1142,1143],"class_list":["post-2870","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-criar-calendario-no-excel","tag-criar-calendario-a-partir-de-dados-de-planilhas-do-excel","tag-criar-calendario-no-excel","tag-crie-um-calendario-no-excel-usando-o-controle-de-selecao-de-data","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>3 maneiras Para Criar Calend\u00e1rio No Excel<\/title>\n<meta name=\"description\" content=\"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio 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:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 maneiras Para Criar Calend\u00e1rio No Excel\" \/>\n<meta property=\"og:description\" content=\"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-04-27T10:52:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T11:55:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"980\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"14 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"3 maneiras Para Criar Calend\u00e1rio No Excel\",\"datePublished\":\"2021-04-27T10:52:34+00:00\",\"dateModified\":\"2021-07-23T11:55:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel\"},\"wordCount\":2582,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/3-Ways-To-Create-Calendar-In-Excel-pt.png\",\"keywords\":[\"como criar calend\u00e1rio no excel\",\"criar calend\u00e1rio a partir de dados de planilhas do Excel\",\"criar calend\u00e1rio no Excel\",\"Crie um calend\u00e1rio no Excel usando o controle de sele\u00e7\u00e3o de data\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel\",\"name\":\"3 maneiras Para Criar Calend\u00e1rio No Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/3-Ways-To-Create-Calendar-In-Excel-pt.png\",\"datePublished\":\"2021-04-27T10:52:34+00:00\",\"dateModified\":\"2021-07-23T11:55:09+00:00\",\"description\":\"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio no Excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/3-Ways-To-Create-Calendar-In-Excel-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/04\\\/3-Ways-To-Create-Calendar-In-Excel-pt.png\",\"width\":980,\"height\":512,\"caption\":\"3 maneiras Para Criar Calend\u00e1rio No Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/criar-calendario-no-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3 maneiras Para Criar Calend\u00e1rio No Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3 maneiras Para Criar Calend\u00e1rio No Excel","description":"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio 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:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel","og_locale":"en_US","og_type":"article","og_title":"3 maneiras Para Criar Calend\u00e1rio No Excel","og_description":"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio no Excel.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2021-04-27T10:52:34+00:00","article_modified_time":"2021-07-23T11:55:09+00:00","og_image":[{"width":980,"height":512,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"14 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"3 maneiras Para Criar Calend\u00e1rio No Excel","datePublished":"2021-04-27T10:52:34+00:00","dateModified":"2021-07-23T11:55:09+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel"},"wordCount":2582,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png","keywords":["como criar calend\u00e1rio no excel","criar calend\u00e1rio a partir de dados de planilhas do Excel","criar calend\u00e1rio no Excel","Crie um calend\u00e1rio no Excel usando o controle de sele\u00e7\u00e3o de data"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel","name":"3 maneiras Para Criar Calend\u00e1rio No Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png","datePublished":"2021-04-27T10:52:34+00:00","dateModified":"2021-07-23T11:55:09+00:00","description":"Esta postagem cont\u00e9m detalhes sobre como criar um calend\u00e1rio no Excel. Aparte disto, voc\u00ea tamb\u00e9m vai ficar a saber sobre como a Este post cont\u00e9m detalhes sobre como criar calend\u00e1rio no Excel.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/04\/3-Ways-To-Create-Calendar-In-Excel-pt.png","width":980,"height":512,"caption":"3 maneiras Para Criar Calend\u00e1rio No Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/criar-calendario-no-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"3 maneiras Para Criar Calend\u00e1rio No Excel"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2870"}],"version-history":[{"count":7,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2870\/revisions"}],"predecessor-version":[{"id":3372,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2870\/revisions\/3372"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2954"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}