ISBLANK with ISERROR with DATE CALC

[Melcrowne]

I can not seem to get my function to jive. I want it to populate TBD if an error occurs or if the field next to it is blank. I also have 2 DATEDIF incorporated. I have tried writing it forward and backward.

 

[Melcrowne]

=IFERROR(IF(ISBLANK(G25), "TBD", "TBD", IF(G25>E25, DATEDIF(E25, G25, "D")), (-DATEDIF(G25, E25, "D"))))(H25), TBD)

That is my most recent pass. I just need TBD if the field next to it is blank, TBD if there is an error, and appropriate date calculations if neither of those arguments are true. Thanks!!!

 

[AhoyNC]

Try (not sure what H2 is for in your formula):

[TABLE="width: 665"]
<colgroup><col width="665"></colgroup><tbody>[TR]
   [TD="width: 665"]IFERROR(IF(ISBLANK(G25),"TBD",IF(G25>E25,DATEDIF(E25,G25,"D"),-DATEDIF(G25,E25,"D"))),"TBD")[/TD]
 [/TR]
</tbody>[/TABLE]

 

[Melcrowne]

States I've entered too many arguments. Story of my life. Lol.

 

[Melcrowne]

H25 was the selected field for the function and what I wanted to write the ISBLANK against.

 

[AhoyNC]

Still not sure what the H2 is doing as your formula shows checking G25 for a blank.

I'm not getting an argument error with the formula I gave.

Excel Workbook
	E	F	G	H	I
24
25	4/6/2017		#N/A		TBD
26
Sheet