685villa
New Member
- Joined
- Jul 8, 2022
- Messages
- 8
- Office Version
- 365
- 2021
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
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
-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()) |