Cell reference that references blank cell coming back with #value! help.

[685villa]

So I am reworking an Army all-in-one tracker for what we do. One of the basic things is tracking evaluations, called "NCOERs" and I am working on the three columns I,J, and K with formulated info but now getting #VALUE! when the referenced cell is also formulated to blank cells (essentially just the blanks in a table, which is to allow adding more employees to a master name sheet (which is a future task for this workbook)). Thanks!
-V

V3 14G Tracker 31 Dec.xlsx
	I	J	K
5	Last Thru Date	Thru Date	Due
6	22-Jun-22	21-Jun-23	171
7	19-Dec-21	18-Dec-22	-14
8	18-Oct-21	17-Oct-22	-76
9	9-Aug-22	8-Aug-23	219
10	10-May-22	9-May-23	128
11	11-Dec-21	10-Dec-22	-22
12	4-Feb-22	3-Feb-23	33
13	9-Jan-22	8-Jan-23	7
14	5-Jun-21	4-Jun-22	-211
15	10-Feb-22	9-Feb-23	39
16	10-Jul-22	9-Jul-23	189
17	8-Jul-22	7-Jul-23	187
18	10-Jun-22	9-Jun-23	159
19	11-Sep-21	10-Sep-22	-113
20	10-Nov-21	9-Nov-22	-53
21	4-Oct-21	3-Oct-22	-90
22	10-Jan-22	9-Jan-23	8
23	30-Nov-21	29-Nov-22	-33
24	16-Mar-22	15-Mar-23	73
25	25-Nov-21	24-Nov-22	-38
26	3-Jan-22	2-Jan-23	1
27	14-Aug-21	13-Aug-22	-141
28	10-Nov-21	9-Nov-22	-53
29	27-Jul-22	26-Jul-23	206
30	30-Sep-21	29-Sep-22	-94
31	6-Jun-22	5-Jun-23	155
32	22-Jun-22	21-Jun-23	171
33	24-Oct-21	23-Oct-22	-70
34	11-Aug-22	10-Aug-23	221
35	9-Jan-22	8-Jan-23	7
36	10-Jun-22	9-Jun-23	159
37	14-Oct-22	13-Oct-23	285
38	2-Aug-22	1-Aug-23	212
39	29-Apr-22	28-Apr-23	117
40	13-Mar-22	12-Mar-23	70
41	9-Nov-22	8-Nov-23	311
42			#VALUE!
43			#VALUE!
44			#VALUE!
45			#VALUE!
46			#VALUE!
47			#VALUE!
48			#VALUE!
49			#VALUE!
50			#VALUE!
51			#VALUE!
52			#VALUE!
53			#VALUE!
54			#VALUE!
55			#VALUE!
NCOERs

Cell Formulas
Range	Formula
J6:J55	J6	=IF(ISBLANK(I6),"",I6+364)
K6:K55	K6	=IF(ISERROR(ISBLANK(J6-TODAY)),"",J6-TODAY())

 

[jasonb75]

Isblank only works with empty cells, not formula blanks.

=IFERROR(J6- TODAY(),"")

 

[Alex Blakenburg]

Or

=IF(J6="","",J6-TODAY())

 

[685villa]

Or

=IF(J6="","",J6-TODAY())

Thank you so much! This worked!

 

[Alex Blakenburg]

You're welcome. Glad we could help.