Kwai Logo
Kwai User Avatar
Nessa dica eu mostro como criar um calendário automático no Excel usando a função sequência. Abaixo você tem a fórmula completa que usei..lembrando que na célula H3 eu coloquei o Ano e na célula D3 o Mês por Extenso =SEQUÊNCIA(6;7;DATA(H3;MÊS;1)-DIA.DA.SEMANA(DATA(H3;MÊS;1);2)) Comente 👇🏻 aí se você achou desse truque! Salve, curta e compartilhe esse post para distribuir conteúdo de qualidade!! . . . . #dicasexcel #usandooexcel #dicasparaexcel #dashboards
39
Comentar
📆✨ Otimize seu tempo no Excel com esta dica incrível! 🚀 Se você precisa preencher automaticamente uma sequência de datas em anos, siga esses passos simples: 1️⃣ Insira a data inicial na célula desejada. 2️⃣ Segure a alça de preenchimento com o mouse. 3️⃣ Arraste para baixo ou para o lado, e solte. 💬 O Excel inteligentemente preencherá automaticamente a sequência de datas em anos, acompanhando o padrão que você começou. Prático, né?
12
Comentar
Carregando
kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwaikwai kwaikwaikwaikwaikwaikwaikwaikwaikwaikwai