Forum Discussion
Solved
Summing the algorithm datedif
HELLO I HAVE A PROBLEM OF CALCULATION! I USED THE FUNCTION DATEDIF TO FIND THE DIFFERENCE BETWEEN MANY DIFFRENT DATES AND THE RESULT IS THESESONE " .... years...months..days " FOR EACH CALCULATE WHIC...
Could you please illustrate on small sample file what you try to do.
THANK YOU VERY MUCH I THINK I HAVE STARTED A WAY TO FIGURE OUT
BUT AS YOU SAID BEFORE I WILL HAVE A MISMUCH WITH THE DAYS 28-29-30-31 DAYS TO FIND A SOLLUTION I USED OTHER ALGORITHM
=INT(G2/365)&" Year(s), "&INT(MOD(G2;365)/30)&" Month(s) and "&MOD(MOD(G2;365);30)&" Day(s)"
SO I COULD FIND A WAY THANK YOU
BUT AS YOU SAID BEFORE I WILL HAVE A MISMUCH WITH THE DAYS 28-29-30-31 DAYS TO FIND A SOLLUTION I USED OTHER ALGORITHM
=INT(G2/365)&" Year(s), "&INT(MOD(G2;365)/30)&" Month(s) and "&MOD(MOD(G2;365);30)&" Day(s)"
SO I COULD FIND A WAY THANK YOU
Main question here is how many days per month to take, formulae could be different. If 30 is okay with you that's fine. But compare to formulas in previous post it could be even bigger difference with actual periods.