Row 3 keeps fighting Me

[Mberry]

=IF(AND(G2>TODAY(),H2="In Process"),"N/A",(DATEDIF(D2,TODAY(),"d")))I need it to return the value of 28Above in the formula I have in my report, however it's not giving me the correct value. I need it to return the value of 28.
Ideally I'm trying to accomplish a formula that will accomplish this..

=IF(D2>TODAY(),"Not Started",(IF(AND(G2>TODAY(),H2="In Process"),"N/A",(DATEDIF(D2,TODAY(),"d")))))
It'll return "Not Started" if the submission due date is later than TODAY(), and N/A if the remediation due date is later than TODAY() AND the status is "In Process". Otherwise it should return the difference in days between Column D and TODAY()

Can anyone help me identify my error?

 

[Fluff]

Not quite sure what your problem is, but your formula is working for me
Excel 2013 32 bit

	D	E	F	G	H	I
In Process
In Process
In Process	N/A
In Process
??
In Process	Not Started

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]2[/TD]
[TD="align: right"]18/08/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]20/08/2017[/TD]

[TD="align: right"]7[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]01/08/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]25/08/2017[/TD]

[TD="align: right"]24[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]28/07/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]26/08/2017[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]28/07/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]20/08/2017[/TD]

[TD="align: right"]28[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]23/07/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]26/08/2017[/TD]

[TD="align: right"]33[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]28/08/2017[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]26/08/2017[/TD]

</tbody>

Data​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]I2[/TH]
[TD="align: left"]=IF(D2>TODAY(),"Not Started",(IF(AND(G2>TODAY(),H2="In Process"),"N/A",(DATEDIF(D2,TODAY(),"d")))))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Mberry]

hmm.. which cell did you place the formula? Based on the format above

 

[Fluff]

I2 & copied down.

 

[Mberry]

If I plug that in, for the first row I end up as “Not Started” when it is and
should be listed as “N/A” (which would be a failure of the very first
condition). If I change it to D2<, it works fine… but then doesn’t
work down in Row 7+.

 

[Fluff]

Could you upload your file to somewhere like Onedrive & post a link to it?
As your formula worked for me it's very difficult to diagnose problems remotely.