Error on subtracting Today() as later date than the other date using DATEDIF

Crusin18 · Feb 14th 2020

=IF(AND(IFERROR(DATEDIF(TODAY(),AV2,"d")>=0,),AU2=""),"COMING SOON",

IFERROR(DATEDIF(TODAY(),AV2,"d"),"OVERDUE")),

IF(AND(AND(C6="BUILDING PERMIT"),(AV6-AU6)<0),"NOT COMPLIANT",

IF(AND(AND(C6="BUILDING PERMIT"),(AV6-AU6)>=0),"COMPLIANT",

IF(AND(AND(C6="OCCUPANCY PERMIT"),(AV6-AU6)<0),"NOT COMPLIANT",

IF(AND(AND(C6="OCCUPANCY PERMIT"),(AV6-AU6)>=0),"COMPLIANT",""))))

i get an error of #value!

I wanted to get the OVERDUE value but instead it gives me an error of #Value!

Maqbool · Feb 17th 2020

Hi

Can you please post a sample workbook with expected results?

**rory** · Feb 17th 2020

I'd say you either have a #VALUE error in C6, or at least one of AV6 or AU6 is not numeric.

**royUK** · Feb 17th 2020

Remove IFERROR until the formulas works as expected.

Participate now!