Trouble on #NUM display

[Ferr_88]

Good day fellows!

Newbie here...
I'm having a hard time eliminating the #NUM display in column K when it is not over-due...I just want it to be blank...
I've searched some #NUM error-related threads but could not find any solution to what i'm into...
I know you guys and gurus have solutions for this... by the way, I'm using Office 2010/Win7. Thanks in advance...

Ferr™

DATA	Thursday, July 11, 2013
A	B	C	D	E	F	G	H	I	J	K	L
DATE	INVOICE NO.	S.O. NO.	QTY	UNIT PRICE	CLIENT NAME	ADDRESS	TERMS(days)	AMOUNT	DUE DATE	DAYS OVER	REMARKS	CHECK DATE	CHECK NO.	AMOUNT	DISCREPANCY
5-Mar-13	10001	210301	1000	200.00	CUSTOMER A	MLA	7	200,000.00	12-Mar-13	121	UNPAID	10-Mar	1001	198,000.00	2,000.00
5-Mar-13	10002	210302	1000	205.00	CUSTOMER B	MLA	15	205,000.00	20-Mar-13	113	PAID	20-Mar	2501	206,000.00	(1,000.00)
5-Mar-13	10003	210303	1000	210.00	CUSTOMER C	MLA	20	210,000.00	25-Mar-13	108	UNPAID	26-Mar	3501	150,000.00	60,000.00
5-Mar-13	10004	210304	1000	215.00	CUSTOMER D	MLA	30	215,000.00	4-Apr-13	98	UNPAID		CASH	210,000.00	5,000.00
5-Mar-13	10005	210305	1000	220.00	CUSTOMER E	MLA	45	220,000.00	19-Apr-13	83	PAID		CASH	225,000.00	(5,000.00)
25-Apr-13	10006	210306	1000	220.00	CUSTOMER F	MLA	15	220,000.00	10-May-13	62	PAID		CASH	220,000.00	-
30-Apr-13	10007	210307	1000	220.00	CUSTOMER G	MLA	60	220,000.00	29-Jun-13	12	PAID		CASH	220,000.00	-
1-May-13	10008	210308	1000	225.00	CUSTOMER H	MLA	20	225,000.00	21-May-13	51	UNPAID				225,000.00
5-May-13	10009	210309	1000	220.00	CUSTOMER I	MLA	15	220,000.00	20-May-13	52	UNPAID				220,000.00
10-May-13	10010	210310	1000	220.00	CUSTOMER J	MLA	60	220,000.00	9-Jul-13	2	UNPAID				220,000.00
10-May-13	10011	210311	1000	220.00	CUSTOMER K	MLA	30	220,000.00	9-Jun-13	32	UNPAID				220,000.00
10-Jul-13	10012	210312	1000	220.00	CUSTOMER L	MLA	7	220,000.00	17-Jul-13	#NUM!	UNPAID				220,000.00
1-Jul-13	10013	210313	1000	220.00	CUSTOMER K	MLA	15	220,000.00	16-Jul-13	#NUM!	UNPAID				220,000.00
								2,815,000.00						1,429,000.00

<tbody>
</tbody>

Formula used: Column "K" : =IF((DATEDIF(A3+H3,NOW(),"d")),(DATEDIF(A3+H3,NOW(),"d")),"") or perhaps a simplified one will be much appreciated...
Column "L" : =IF(I3<=O3,"PAID","UNPAID")

 

[FormR]

Hi; for column K try:

=IF(TODAY()-(A3+H3)>0,TODAY()-(A3+H3),"")

You may need to format the cells as number.

 

[Ferr_88]

Hi; for column K try:

=IF(TODAY()-(A3+H3)>0,TODAY()-(A3+H3),"")

You may need to format the cells as number.

thanks a lot for your quick response!
will look forward to your formula in a a couple of minutes...
anyway, for the meantime, I ended up with the conditional formatting - tweaking just the font/background color of a "column K" using white...

 

[Ferr_88]

Thanks FormR! i use your formula and it works great...
however, when there is no data yet for the succeeding rows below, "0-Jan-00" appears in "Column J" (i want it blank) - used Formula : =A3+H3
and in "Column K", numbers "41466" appears also...how do i make it become blank also?
One more thing, is it possible for the "Column L" be empty/blank if the days in "Column K" are not past due?

Thank you once again and I'm hoping that my problems be solved.

To the admins and mods, please bear with me...Thank you!

 

[FormR]

Try:

Column J:

=IF(A3="","",A3+H3)

Column K:

=IF(A3="","",IF(TODAY()-(A3+H3)>0,TODAY()-(A3+H3),""))

Column L:

=IF(K3="","",IF(I3<=O3,"PAID","UNPAID"))

 

[Ferr_88]

Try:

Column J:

=IF(A3="","",A3+H3)

Column K:

=IF(A3="","",IF(TODAY()-(A3+H3)>0,TODAY()-(A3+H3),""))

Column L:

=IF(K3="","",IF(I3<=O3,"PAID","UNPAID"))

I am having so much fulfillment because it's done! Yes! my spreadsheet now has the formulas i needed and contains no error anymore!
I thank you so much for your effortless time i guess...