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
2	18/08/2017			20/08/2017	In Process	7
3	01/08/2017			25/08/2017	In Process	24
4	28/07/2017			26/08/2017	In Process	N/A
5	28/07/2017			20/08/2017	In Process	28
6	23/07/2017			26/08/2017	??	33
7	28/08/2017			26/08/2017	In Process	Not Started

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Data​

Worksheet Formulas Cell Formula I2 =IF(D2>TODAY(),"Not Started",(IF(AND(G2>TODAY(),H2="In Process"),"N/A",(DATEDIF(D2,TODAY(),"d"))))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[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.