Jimbo Jones
New Member
- Joined
- May 12, 2021
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
I need a formula to return the Maintenance Date(Column B)(Maintenance Date Worksheet) to the Actual Ship & Return Dates Worksheet in Column C. Basically the Asset has a serial number; it is shipped to the worksite then returned to the base, maintenance is performed, then the serialized asset is returned to the worksite. The transactions are done in two different computer systems which is why i need to join the date ranges to make sure Maintenance is being done between the actual ship date and the return date. The unique identifier is the serial number column on both worksheets.
MR EXCEL WORKBOOK.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Lot Serial Number | Actual Ship Date | Maintenance Date | Return Date | ||
56 | CEM010 | 11/24/2020 | 11/29/2020 | |||
57 | CEM010 | 11/24/2020 | 11/26/2020 | |||
58 | CEM010 | 11/24/2020 | 11/26/2020 | |||
59 | CEM011 | 10/3/2020 | 10/5/2020 | |||
60 | CEM011 | 10/9/2020 | 10/20/2020 | |||
61 | CEM011 | 10/18/2020 | 10/21/2020 | |||
62 | CEM011 | 10/19/2020 | 10/23/2020 | |||
63 | CEM011 | 10/24/2020 | 10/25/2020 | |||
64 | CEM011 | 10/25/2020 | 11/1/2020 | |||
65 | CEM011 | 10/25/2020 | 10/30/2020 | |||
66 | CEM011 | 10/25/2020 | 10/30/2020 | |||
67 | CEM011 | 10/28/2020 | 11/3/2020 | |||
68 | CEM011 | 11/1/2020 | 11/2/2020 | |||
69 | CEM011 | 11/2/2020 | 11/9/2020 | |||
70 | CEM011 | 11/5/2020 | 11/9/2020 | |||
71 | CEM011 | 11/5/2020 | 11/7/2020 | |||
72 | CEM011 | 11/10/2020 | 11/12/2020 | |||
73 | CEM014 | 10/18/2020 | 10/22/2020 | |||
74 | CEM014 | 10/28/2020 | 11/8/2020 | |||
75 | CEM014 | 11/12/2020 | 11/20/2020 | |||
76 | CEM014 | 11/24/2020 | 12/3/2020 | |||
77 | CEM014 | 12/4/2020 | 12/6/2020 | |||
78 | CEM014 | 12/11/2020 | 12/15/2020 | |||
79 | CEM014 | 12/15/2020 | 12/24/2020 | |||
80 | CEM014 | 1/2/2021 | 1/5/2021 | |||
81 | CEM014 | 2/15/2021 | 2/21/2021 | |||
82 | CEM014 | 3/14/2021 | 3/14/2021 | |||
83 | CEM014 | 3/19/2021 | 3/22/2021 | |||
84 | CEM014 | 4/5/2021 | 4/15/2021 | |||
85 | CEM018 | 11/12/2020 | 11/14/2020 | |||
86 | CEM018 | 11/15/2020 | 11/16/2020 | |||
87 | CEM018 | 11/17/2020 | 11/18/2020 | |||
88 | CEM018 | 1/3/2021 | 1/9/2021 | |||
89 | CEM018 | 1/4/2021 | 1/7/2021 | |||
90 | CEM018 | 1/6/2021 | 1/9/2021 | |||
91 | CEM018 | 1/6/2021 | 1/9/2021 | |||
92 | CEM018 | 1/20/2021 | 1/31/2021 | |||
93 | CEM018 | 1/31/2021 | 1/31/2021 | |||
94 | CEM018 | 2/1/2021 | 2/19/2021 | |||
95 | CEM018 | 2/1/2021 | 2/8/2021 | |||
96 | CEM018 | 2/3/2021 | 2/11/2021 | |||
97 | CEM018 | 2/7/2021 | 2/11/2021 | |||
98 | CEM018 | 2/14/2021 | 2/17/2021 | |||
99 | CEM018 | 2/14/2021 | 2/16/2021 | |||
100 | CEM018 | 2/14/2021 | 2/15/2021 | |||
101 | CEM018 | 2/21/2021 | 2/28/2021 | |||
102 | CEM018 | 2/21/2021 | 2/24/2021 | |||
103 | CEM018 | 2/21/2021 | 2/22/2021 | |||
104 | CEM018 | 3/3/2021 | 3/6/2021 | |||
105 | CEM018 | 3/7/2021 | 3/11/2021 | |||
106 | CEM018 | 3/7/2021 | 3/10/2021 | |||
107 | CEM018 | 3/7/2021 | 3/10/2021 | |||
108 | CEM018 | 3/7/2021 | 3/7/2021 | |||
109 | CEM018 | 3/7/2021 | 3/7/2021 | |||
Actual Ship & Return Dates |
MR EXCEL WORKBOOK.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | Serial Num | Maintenance Date | ||
11 | CEM001 | 11/27/2020 | ||
12 | CEM001 | 11/28/2020 | ||
13 | CEM001 | 11/30/2020 | ||
14 | CEM006 | 11/24/2020 | ||
15 | CEM006 | 11/25/2020 | ||
16 | CEM007 | 11/24/2020 | ||
17 | CEM007 | 11/27/2020 | ||
18 | CEM007 | 11/30/2020 | ||
19 | CEM010 | 7/18/2020 | ||
20 | CEM010 | 9/8/2020 | ||
21 | CEM010 | 10/2/2020 | ||
22 | CEM010 | 10/20/2020 | ||
23 | CEM010 | 11/20/2020 | ||
24 | CEM010 | 11/27/2020 | ||
25 | CEM011 | 9/23/2020 | ||
26 | CEM011 | 11/22/2020 | ||
27 | CEM011 | 4/20/2021 | ||
28 | CEM014 | 8/4/2020 | ||
29 | CEM014 | 9/25/2020 | ||
30 | CEM014 | 9/27/2020 | ||
31 | CEM014 | 9/28/2020 | ||
32 | CEM014 | 9/28/2020 | ||
33 | CEM014 | 9/28/2020 | ||
34 | CEM014 | 9/29/2020 | ||
35 | CEM014 | 10/6/2020 | ||
36 | CEM014 | 11/1/2020 | ||
37 | CEM014 | 11/10/2020 | ||
38 | CEM014 | 11/11/2020 | ||
39 | CEM014 | 11/22/2020 | ||
40 | CEM014 | 11/24/2020 | ||
41 | CEM014 | 12/9/2020 | ||
42 | CEM014 | 12/11/2020 | ||
43 | CEM014 | 1/5/2021 | ||
44 | CEM014 | 1/23/2021 | ||
45 | CEM014 | 1/30/2021 | ||
46 | CEM014 | 2/14/2021 | ||
47 | CEM014 | 2/14/2021 | ||
48 | CEM014 | 2/19/2021 | ||
49 | CEM014 | 2/21/2021 | ||
50 | CEM018 | 6/26/2020 | ||
51 | CEM018 | 6/29/2020 | ||
52 | CEM018 | 9/6/2020 | ||
53 | CEM018 | 9/6/2020 | ||
54 | CEM018 | 9/16/2020 | ||
55 | CEM018 | 9/24/2020 | ||
56 | CEM018 | 9/26/2020 | ||
57 | CEM018 | 10/20/2020 | ||
58 | CEM018 | 11/20/2020 | ||
59 | CEM018 | 12/6/2020 | ||
60 | CEM018 | 12/8/2020 | ||
61 | CEM018 | 12/26/2020 | ||
62 | CEM018 | 12/26/2020 | ||
63 | CEM018 | 12/26/2020 | ||
64 | CEM018 | 12/26/2020 | ||
65 | CEM018 | 1/4/2021 | ||
66 | CEM018 | 1/13/2021 | ||
67 | CEM018 | 1/22/2021 | ||
68 | CEM018 | 1/31/2021 | ||
69 | CEM018 | 2/5/2021 | ||
70 | CEM018 | 2/11/2021 | ||
71 | CEM018 | 2/13/2021 | ||
72 | CEM018 | 2/24/2021 | ||
73 | CEM018 | 3/7/2021 | ||
74 | CEM018 | 3/13/2021 | ||
75 | CEM018 | 3/31/2021 | ||
76 | CEM018 | 4/7/2021 | ||
77 | CEM018 | 4/24/2021 | ||
78 | CEM018 | 4/25/2021 | ||
79 | CEM018 | 4/25/2021 | ||
80 | CEM018 | 4/26/2021 | ||
MAINTENANCE DATE |