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

[Gildo_Pinheiro]

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")

[#2]

@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"))

[#3]

unfortunately it didn't work,

[#4]

@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"))

[#5 · Accepted solution]

its work perfectly, thank you very much