Mute
Max Planilhas
Você sabia que dá pra calcular automaticamente o tempo de permanência no Excel? 🤯 No vídeo, aplicamos a função da seguinte forma: DATADIF(C5;HOJE();"Y") & " ano(s) e " & DATADIF(C5;HOJE();"YM") & " mes(es)" ➡ C5 → referência data de cadastro ➡ HOJE() → data atual ➡ "Y" → anos completos ➡ "YM" → meses restantes Gostou da nossa dica? Curta ❤ e siga nossa página. #excel #maxplanilhas #exceltips #FunçõesExcel
Follow
73
1
40
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