Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,226
- Office Version
- 365
- Platform
- Windows
HI All,
I have a table showing dates when they where completed, as below.
When a task is completed it is added to the entry table and it shows in here as being green. What I would like is at the end of the list is to add on when the next revision is due. So, for Task 1 the next due date is 28th Feb 24, Task 3 would be 29th Jun 24 and Task 5 would be 12th Aug 23. I would look like below.
Thanks in Advance
I have a table showing dates when they where completed, as below.
GD Task Master.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
K | L | M | N | O | P | Q | R | |||
2 | Staff Member | |||||||||
11 | A Person | |||||||||
12 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | |||
13 | Task 1 | 28-Feb-23 | ||||||||
14 | Task 2 | 17-Feb-23 | ||||||||
15 | Task 3 | 08-Jul-22 | 29-Jun-23 | |||||||
16 | Task 4 | 17-Feb-23 | ||||||||
17 | Task 5 | 12-May-23 | ||||||||
18 | Task 6 | 12-May-23 | ||||||||
19 | Task 7 | 13-Apr-23 | 29-Jun-23 | |||||||
Person View |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L13:L14,L16:L18,L19:M19,L15:M15 | L13 | =TRANSPOSE(FILTER(Entry[Date Complete],((Entry[Staff Member]=$B$2)*(Entry[Activity]=B13)))) |
When a task is completed it is added to the entry table and it shows in here as being green. What I would like is at the end of the list is to add on when the next revision is due. So, for Task 1 the next due date is 28th Feb 24, Task 3 would be 29th Jun 24 and Task 5 would be 12th Aug 23. I would look like below.
Thanks in Advance