SOLVED

Datedif, when I had the end date stop counting, it is possible

%3CLINGO-SUB%20id%3D%22lingo-sub-2419837%22%20slang%3D%22pt-BR%22%3EDatedif%2C%20when%20I%20had%20the%20end%20date%20stop%20counting%2C%20it%20is%20possible%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2419837%22%20slang%3D%22pt-BR%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%20friends%2C%20I%20come%20through%20to%20ask%20for%20your%20help.%3C%2FP%3E%3CP%3EI%20have%20the%20formula%20to%20calculate%20the%20DATEDIF%20Dates%20with%20the%20function%20today%2C%20I%20would%20like%20that%20when%20I%20had%20the%20end%20date%20stop%20counting%2C%20it%20is%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20formula.%3C%2FP%3E%3CP%3E%3DIF(LEN(%5B%40%5BLicense%20Date%5D))%3D0%3B%22%20%22%3BD%20ATEDIF(%20%5B%40%5BLicense%20Date%5D%5D%3B%20TODAY()%3B%22%20y%22)%20%26amp%3B%20%22%20years%20%22%20%26amp%3B%20MOD(DATEDIF(%5B%40%5BLicense%20Date%5D%5D%3B%20TODAY()%3B%22%20ym%22)%3B12)%20%26amp%3B%20%22%20months%20%22%20%26amp%3B%20MOD(MOD(DATEDIF(%20%5B%40%5BLicense%20Date%5D%5D%3B%20TODAY()%3B%22%20md%22)%3B365)%3B12)%20%26amp%3B%20%22days%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Gildo_Pinheiro_1-1622986865518.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286622i028EBB284DC5B1AC%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Gildo_Pinheiro_1-1622986865518.png%22%20alt%3D%22Gildo_Pinheiro_1-1622986865518.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2419837%22%20slang%3D%22pt-BR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2419976%22%20slang%3D%22en-US%22%3ERe%3A%20Datedif%2C%20when%20I%20had%20the%20end%20date%20stop%20counting%2C%20it%20is%20possible%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2419976%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735858%22%20target%3D%22_blank%22%3E%40Gildo_Pinheiro%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3D%22%22%3B%22%22%3BIF(%5B%40%5BData%20da%20Retorno%5D%5D%3D%22%22%3BDATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3BTODAY()%3B%22y%22)%20%26amp%3B%20%22%20anos%20%22%20%26amp%3B%20DATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3BTODAY()%3B%22ym%22)%20%26amp%3B%20%22%20meses%20%22%20%26amp%3B%20DATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3BTODAY()%3B%22md%22)%20%26amp%3B%20%22%20dias%22)%3BDATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3B%5B%40%5BData%20da%20Retorno%5D%5D%3B%22y%22)%20%26amp%3B%20%22%20anos%20%22%20%26amp%3B%20DATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3B%5B%40%5BData%20da%20Retorno%5D%5D%3B%22ym%22)%20%26amp%3B%20%22%20meses%20%22%20%26amp%3B%20DATEDIF(%5B%40%5BData%20da%20Licen%C3%A7a%5D%5D%3B%5B%40%5BData%20da%20Retorno%5D%5D%3B%22md%22)%20%26amp%3B%20%22%20dias%22))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2420387%22%20slang%3D%22pt-BR%22%3ERe%3A%20Datedif%2C%20when%20I%20had%20the%20end%20date%20stop%20counting%2C%20it%20is%20possible%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2420387%22%20slang%3D%22pt-BR%22%3Eunfortunately%20it%20didn't%20work%2C%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

 

Hello friends, I come through to ask for your help.

I have the formula to calculate the DATEDIF Dates with the function today, I would like that when I had the end date stop counting, it is possible.

 

My formula.

=IF(LEN([@[Data da Licença]])=0;" ";DATEDIF( [@[Data da Licença]];TODAY();"y") & " anos " & MOD(DATEDIF([@[Data da Licença]];TODAY();"ym");12) & " meses " & MOD(MOD(DATEDIF( [@[Data da Licença]];TODAY();"md");365);12) & " dias")

 

Gildo_Pinheiro_1-1622986865518.png

 

4 Replies

@Gildo_Pinheiro 

Try

 

=IF([@[Data da Licença]]="";"";IF([@[Data da Retorno]]="";DATEDIF([@[Data da Licença]];TODAY();"y") & " anos " & DATEDIF([@[Data da Licença]];TODAY();"ym") & " meses " & DATEDIF([@[Data da Licença]];TODAY();"md") & " dias");DATEDIF([@[Data da Licença]];[@[Data da Retorno]];"y") & " anos " & DATEDIF([@[Data da Licença]];[@[Data da Retorno]];"ym") & " meses " & DATEDIF([@[Data da Licença]];[@[Data da Retorno]];"md") & " dias"))

unfortunately it didn't work,

@Gildo_Pinheiro 

Sorry, there were a few typos.

 

=IF([@[Data da Licença]]="";"";IF([@[Data de Retorno]]="";DATEDIF([@[Data da Licença]];TODAY();"y") & " anos " & DATEDIF([@[Data da Licença]];TODAY();"ym") & " meses " & DATEDIF([@[Data da Licença]];TODAY();"md") & " dias";DATEDIF([@[Data da Licença]];[@[Data de Retorno]];"y") & " anos " & DATEDIF([@[Data da Licença]];[@[Data de Retorno]];"ym") & " meses " & DATEDIF([@[Data da Licença]];[@[Data de Retorno]];"md") & " dias"))

best response confirmed by Gildo_Pinheiro (Occasional Contributor)
Solution
its work perfectly, thank you very much