Dipwind wrote:
Franz,
http://www.savefile.com/files/1345175
Hi Joćo,
there were two extra space inside the first DATEDIF function in the second
part of IF, maybe due to copy & past...
So the right formula should be:
=IF(D5<"",DATEDIF(C5,D5,"y")&"y"&IF(DATEDIF(C5,D5 ,"YM")=0,"",DATEDIF(C5,$B$2,"YM"
)&"m")&IF(DATEDIF(C5,D5,"md")=0,"",DATEDIF(C5,D5," MD" )&"D"),DATEDIF(C5,$B$2,"y")&"y"&IF(DATEDIF(C5,$B$2 ,"YM")=0,"",DATEDIF(C5,$B$2,"YM")&"m")&IF(DATEDIF( C5,$B$2,"MD")=0,"",DATEDIF(C5,$B$2,"MD")&"d"))
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy