#NUM! ERROR

[SRMPURCHASE]

I42 IS SHOWING THE #NUM! ERROR. WHEN I COPY THE FORMULA FROM I41 THE DATEDIF FORMULA WORKS, WHEN I INPUT 1-15-23 IT FAILS WITH THE #NUM! ERROR. ALL FORMATTING IS THE SAME, NOT SURE HOW THE DATE CHANGE IN H42 WILL CAUSE THE FORMULA TO WORK OR NOT WORK HERE'S THE FORMULA $I$32 IS THE DATE 19-JAN-24 =IF(G42>0,(DATEIF($I$32,H42,"M")),"")		19-Jan-24
G	H	I
15-Jan-23	15-Jan-20
20-Nov-22	20-Nov-24	10.0
20-Nov-22	20-Nov-25	22.0
12-Sep-22	12-Sep-27	43.0
11-Mar-23	11-Mar-26	25.0
11-Mar-23	11-Mar-26	25.0
11-Mar-20	11-Mar-25	13.0
11-Mar-20	11-Mar-25	13.0
15-Jan-20	15-Jan-23	#NUM!
27-May-23	27-May-26	28.0
27-May-23	27-May-26	28.0

 

[dreid1011]

It looks like it is returning #NUM! because your date in I32 is greater than the date in col H for those rows.

 

[SRMPURCHASE]

Got it, figured it out already.