Help with creating a "Meeting minutes" file

DarkoDeign2

Board Regular
Joined
Jun 20, 2023
Messages
76
Office Version
  1. 365
Platform
  1. 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..


Agenda & Minutes (2).xlsx
ABCDEFGHIJKLMN
1Agenda
2WeekDateTopicPresenter(s)StatusParticipants:Person 1Person 2Person 3Person 4Person 5Person 6Person 7Person 8
3wk302023-07-26sdfasdExcused:
4wk302023-07-26asdfsfsdChair person:Person 1
5wk302023-07-26fsdsdfdfdsMinutes taker:Person 2
6wk302023-07-26sdfdsf
7wk302023-07-26End
8
9
10
11wk312023-08-02derwrwerwerExcused:
12wk312023-08-02dewrgdsfddfChair person:Person 2
13wk312023-08-02erterwrwerMinutes taker:Person 3
14wk312023-08-02tyutyutututy
15wk312023-08-02end
16
17
18
19wk322023-08-09vcxvbxcvbcExcused:Person 4
20wk322023-08-09xcvbxcvbChair person:Person 3
21wk322023-08-09xcvbxcvbMinutes taker:Person 5
22wk322023-08-09xcvbxcvb
23wk322023-08-09xcvbxcbbb
24wk322023-08-09END
2500
2600
2700
2800
2900
Minutes
Cell Formulas
RangeFormula
A19:A29,A12:A15,A3:A7A3=IF(C3="","0",ISOWEEKNUM($B3))
B4:B7,B20:B29,B12:B15B4=IF(C4="","0",B3)
B11B11=SUM(B6+7)
 
Last edited:

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
I managed to almost solve the formula for column B.
But if a cell in Col C has the text "End", then I need the cell, four rows down in Col B (B11) to show =SUM(B6+7)
How do I add this critera to my formula in the cells in col B. I have been thinking if OFFSET should be used or INDEX... But I am a little bit stuck.
All cells in B will have the same formula except for B3 that will contain a date.

Agenda & Minutes (2).xlsx
ABCDEFGHIJKLMN
1Agenda
2WeekDateTopicPresenter(s)StatusParticipants:Person 1Person 2Person 3Person 4Person 5Person 6Person 7Person 8
3wk302023-07-26sdfasdExcused:
4wk302023-07-26asdfsfsdChair person:Person 1
5wk302023-07-26fsdsdfdfdsMinutes taker:Person 2
6wk302023-07-26sdfdsf
7wk302023-07-26End
8 
9  
10  
11wk312023-08-02derwrwerwerExcused:
12wk312023-08-02dewrgdsfddfChair person:Person 2
13wk312023-08-02erterwrwerMinutes taker:Person 3
14wk312023-08-02tyutyutututy
15wk312023-08-02end
Minutes
Cell Formulas
RangeFormula
B4:B7,B10,B12:B15B4=IF(OR(C3="End", C4=""), IF(C3="End", B3+7, ""),B3)
A3:A15A3=IF(C3="","",ISOWEEKNUM($B3))
B9B9=IF(OR(C8="End", C9=""), IF(C8="End", B11+7, ""),B11)
B11B11=IF(OR(C7="End", C8=""), IF(C7="End", B7+7, ""),B7)
 
Last edited:
Upvote 0
Is it possible to have an formula in cell B4:B7000 that adds an empty row between row 7 and 8.
Currently the result of the formula in cell B8, is showed in B8, but I want is the result to be shown on row B9 instead. Is it possible?

Agenda & Minutes (2).xlsx
BC
1Agenda
2DateTopic
32023-07-25BBQ Party
42023-07-25Pay electrical bills
52023-07-25Renew subrscription of newspaper
62023-07-25Get a hair cut
72023-07-25End
82023-08-01PTA meeting
Test (3)
Cell Formulas
RangeFormula
B4:B8B4=IF(OR(C3="End", C4=""), IF(C3="End", B3+7, ""),B3)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A7:I7Expression=IF(C3="End";)textNO
C3:C1048576Cell Valuecontains "End"textNO
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top