Hi. I want to create a weekly project tracking.
This is the step:
1. User enter the required date to fill in the data
2. The formula will automatically display the required week and Monday date
3. User key in project, start, end, status and manager
The problem is:
Assume after filling the data from previous step, I want to fill in another data again into a different date. So, user can follow step 1. But, the problem is, it just update the date only, excluding all the data and the actual date. Is there a way where the data that we entered previously can be locked together with the date that we typed during step 1. Also, if can, I want the latest date to be shown at the right side and previous date at the left side. I already attached the excel file for your reference.
Thank you
This is the step:
1. User enter the required date to fill in the data
2. The formula will automatically display the required week and Monday date
3. User key in project, start, end, status and manager
The problem is:
Assume after filling the data from previous step, I want to fill in another data again into a different date. So, user can follow step 1. But, the problem is, it just update the date only, excluding all the data and the actual date. Is there a way where the data that we entered previously can be locked together with the date that we typed during step 1. Also, if can, I want the latest date to be shown at the right side and previous date at the left side. I already attached the excel file for your reference.
Thank you
| project_tracker.xlsx | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | |||||||||||||||||
| 2 | Date start (Mon) | 3/4/2022 | |||||||||||||||
| 3 | |||||||||||||||||
| 4 | Week 14 | Week 15 | Week 16 | ||||||||||||||
| 5 | 28/3/2022 | 4/4/2022 | 11/4/2022 | ||||||||||||||
| 6 | Project | start | end | status | manager | Project | start | end | status | manager | Project | start | end | status | manager | ||
| 7 | A | 1/3/2022 | 1/6/2022 | in progress | M1 | ||||||||||||
| 8 | B | 1/1/2022 | 1/10/2022 | on hold | M2 | ||||||||||||
| 9 | C | 1/3/2022 | 2/6/2022 | in progress | M3 | ||||||||||||
Sheet1 | |||||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A4,K4,F4 | A4 | =CONCATENATE("Week ",WEEKNUM(A5,2)) |
| A5 | A5 | =B2-WEEKDAY(B2,3) |
| F5,K5 | F5 | =A5+7 |
