DATEDIF value less than 0 shown as NUM!

[Userskphero]

Hello. I have trouble with Google Sheet, not Excel but maybe somebody can help me with this.

I saw a few post about common problem but still can't repair my formula.

=ARRAY_CONSTRAIN(ARRAYFORMULA(if(row($H$2:$H26674)=2,"CZY SKP",if($C$2:$C26674="","",if(datedif(today(),$G$2:$G26674,"d")<100,"SKP NEEDED","")))), 26673, 1)

When amount of days is less than 0 it shows NUM! problem. I want to it show "SKP NEEDED" communicat.

Photo below.

Thanks for help.

 

[Fluff]

Hi & welcome to MrExcel.
Maybe

ARRAY_CONSTRAIN(ARRAYFORMULA(if(row($H$2:$H26674)=2,"CZY SKP",if($C$2:$C26674="","",if($G$2:$G26674-today()<100,"SKP NEEDED","")))), 26673, 1)

 

[Userskphero]

Hi & welcome to MrExcel.
Maybe

ARRAY_CONSTRAIN(ARRAYFORMULA(if(row($H$2:$H26674)=2,"CZY SKP",if($C$2:$C26674="","",if($G$2:$G26674-today()<100,"SKP NEEDED","")))), 26673, 1)

Hello, thank you so much. It's working!

 

[Fluff]

You're welcome & thanks for the feedback.