DarkoDeign2
Board Regular
- Joined
- Jun 20, 2023
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi,
I am creating a file to keep meetin minutes.
In column "B" I have dates for each meeting. Except for the first row I have this formula in cells B4:B7000 =IF(C4="";"0";B3). If Column C is not empty then I want to have the same date in cell B4 as the cell above.
But if a cell in column C should contain the word "End" I want excel to leave 3 blank rows and continue with cell B11 containing the date from =(B7+7days)
When excel skips three rows and jumps from B11, I also want the F3:F5 and G4:G5 on the next week. I want to have Excused, chair person and minutes taker every week and preferabely copied over automatically every time "end" triggers the start of a new week.
In cells G2:N2 I have a list of 8 people that will participate in the meeting every week.
In column G I would like to have a weekly rotation of the chair person and the minutes taker, unless the person is excused, then the task of chair person or minutes taker goes to the next person in line.
All this and I hope that it will still possible to filter cell A2 for the different weeks, despite having 3 blank rows between the weeks? If the three blank rows are creating a problem then we can do with just 1 blank row if that helps..
I am creating a file to keep meetin minutes.
In column "B" I have dates for each meeting. Except for the first row I have this formula in cells B4:B7000 =IF(C4="";"0";B3). If Column C is not empty then I want to have the same date in cell B4 as the cell above.
But if a cell in column C should contain the word "End" I want excel to leave 3 blank rows and continue with cell B11 containing the date from =(B7+7days)
When excel skips three rows and jumps from B11, I also want the F3:F5 and G4:G5 on the next week. I want to have Excused, chair person and minutes taker every week and preferabely copied over automatically every time "end" triggers the start of a new week.
In cells G2:N2 I have a list of 8 people that will participate in the meeting every week.
In column G I would like to have a weekly rotation of the chair person and the minutes taker, unless the person is excused, then the task of chair person or minutes taker goes to the next person in line.
All this and I hope that it will still possible to filter cell A2 for the different weeks, despite having 3 blank rows between the weeks? If the three blank rows are creating a problem then we can do with just 1 blank row if that helps..
Agenda & Minutes (2).xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Agenda | |||||||||||||||
2 | Week | Date | Topic | Presenter(s) | Status | Participants: | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 | Person 6 | Person 7 | Person 8 | ||
3 | wk30 | 2023-07-26 | sdfasd | Excused: | ||||||||||||
4 | wk30 | 2023-07-26 | asdfsfsd | Chair person: | Person 1 | |||||||||||
5 | wk30 | 2023-07-26 | fsdsdfdfds | Minutes taker: | Person 2 | |||||||||||
6 | wk30 | 2023-07-26 | sdfdsf | |||||||||||||
7 | wk30 | 2023-07-26 | End | |||||||||||||
8 | ||||||||||||||||
9 | ||||||||||||||||
10 | ||||||||||||||||
11 | wk31 | 2023-08-02 | derwrwerwer | Excused: | ||||||||||||
12 | wk31 | 2023-08-02 | dewrgdsfddf | Chair person: | Person 2 | |||||||||||
13 | wk31 | 2023-08-02 | erterwrwer | Minutes taker: | Person 3 | |||||||||||
14 | wk31 | 2023-08-02 | tyutyutututy | |||||||||||||
15 | wk31 | 2023-08-02 | end | |||||||||||||
16 | ||||||||||||||||
17 | ||||||||||||||||
18 | ||||||||||||||||
19 | wk32 | 2023-08-09 | vcxvbxcvbc | Excused: | Person 4 | |||||||||||
20 | wk32 | 2023-08-09 | xcvbxcvb | Chair person: | Person 3 | |||||||||||
21 | wk32 | 2023-08-09 | xcvbxcvb | Minutes taker: | Person 5 | |||||||||||
22 | wk32 | 2023-08-09 | xcvbxcvb | |||||||||||||
23 | wk32 | 2023-08-09 | xcvbxcbbb | |||||||||||||
24 | wk32 | 2023-08-09 | END | |||||||||||||
25 | 0 | 0 | ||||||||||||||
26 | 0 | 0 | ||||||||||||||
27 | 0 | 0 | ||||||||||||||
28 | 0 | 0 | ||||||||||||||
29 | 0 | 0 | ||||||||||||||
Minutes |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A19:A29,A12:A15,A3:A7 | A3 | =IF(C3="","0",ISOWEEKNUM($B3)) |
B4:B7,B20:B29,B12:B15 | B4 | =IF(C4="","0",B3) |
B11 | B11 | =SUM(B6+7) |
Last edited: