Datedif: Error: You've entered too many arguments for this Fuction

[Charlene Durand]

please help i have this formula and it is giving me a Error: You've entered too many arguments for this Fuction

=IFERROR(IF(DATEDIF($V15,$W15,"y")=0,"",DATEDIF($V15,$W15,"y")&"y ")&IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m "),IF(DATEDIF($V15,$AI15,"y")=0,"",DATEDIF($V15,$AI15,"y")&"y ")&IF(DATEDIF($V15,$AI15,"ym")=0,"",DATEDIF($V15,$AI15,"ym")&" m "),IF(DATEDIF($AI15,today(),"y")=0,"",DATEDIF($AI15,today(),"y")&"y ")&IF(DATEDIF($AI15,today(),"ym")=0,"",DATEDIF($AI15,today(),"ym")&" m ")))

 

[Aladin Akyurek]

Looks like you missed some ampersands...

=IFERROR(IF(DATEDIF($V15,$W15,"y")=0,"",DATEDIF($V15,$W15,"y")&"y ")&IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m ")&IF(DATEDIF($V15,$AI15,"y")=0,"",DATEDIF($V15,$AI15,"y")&"y ")&IF(DATEDIF($V15,$AI15,"ym")=0,"",DATEDIF($V15,$AI15,"ym")&" m ")&IF(DATEDIF($AI15,TODAY(),"y")=0,"",DATEDIF($AI15,TODAY(),"y")&"y ")&IF(DATEDIF($AI15,TODAY(),"ym")=0,"",DATEDIF($AI15,TODAY(),"ym")&" m "),"")

Note I did not check the logic.

 

[Charlene Durand]

this is what my original formula was:

=IFERROR(IF(DATEDIF($V15,$W15,"y")=0,"",DATEDIF($V15,$W15,"y")&"y ")&IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m "),IF(DATEDIF($V15,$AI15,"y")=0,"",DATEDIF($V15,$AI15,"y")&"y ")&IF(DATEDIF($V15,$AI15,"ym")=0,"",DATEDIF($V15,$AI15,"ym")&" m "))

i then wanted to add

,IF(DATEDIF($AI15,TODAY(),"y")=0,"",DATEDIF($AI15,TODAY(),"y")&"y ")&IF(DATEDIF($AI15,TODAY(),"ym")=0,"",DATEDIF($AI15,TODAY(),"ym")&" m ")

this is when the fault came in

 

[Aladin Akyurek]

So correcting for ampersands did not deliver the result you want?

Care to explain what this means?

IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m "),IF(DATEDIF($V15,$AI15,"y")=0,"",DATEDIF($V15,$AI15,"y")&"y ")&

 

[Charlene Durand]

I have a Engament Date Termination date then start of new job title and i want to get a result of Yers of service in job title

 

[Aladin Akyurek]

I have a Engament Date Termination date then start of new job title and i want to get a result of Yers of service in job title

Doesn't the edit of post #2 work for you?

 

[Charlene Durand]

Hi no it does not as it gives me a blank for all

this is yours:

=IFERROR(IF(DATEDIF($V15,$W15,"y")=0,"",DATEDIF($V15,$W15,"y")&"y ")&IF(DATEDIF($V15,$W15,"ym")=0,"",DATEDIF($V15,$W15,"ym")&" m ")&IF(DATEDIF($V15,$AI15,"y")=0,"",DATEDIF($V15,$AI15,"y")&"y ")&IF(DATEDIF($V15,$AI15,"ym")=0,"",DATEDIF($V15,$AI15,"ym")&" m ")&IF(DATEDIF($AI15,TODAY(),"y")=0,"",DATEDIF($AI15,TODAY(),"y")&"y ")&IF(DATEDIF($AI15,TODAY(),"ym")=0,"",DATEDIF($AI15,TODAY(),"ym")&" m "),"")

I then deleted the ,"") at the very end and then it gives me #num!

 

[Aladin Akyurek]

This is not mine as I did not suggest any formula, only edited yours for ampersands which are possibly missing.

It's perhaps better that you describe the problem which you want to solve in words by giving examples.