Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

Household Chores Roster in Excel (card 1 of 2)

Revision card 1 for Household Chores Roster in Excel: Number of members: =COUNTA(A6:A9) gives 4; Next week's start date: =D6+7 gives 05-10-2026; Who does chore 1 in week 1: =INDEX($A$6:$A$9,MOD($C6-1+0,$B$10)+1) gives Ravindra. Includes an example data table.

Revision card 1 for Household Chores Roster in Excel: Number of members: =COUNTA(A6:A9) gives 4; Next week's start date: =D6+7 gives 05-10-2026; Who does chore 1 in week 1: =INDEX($A$6:$A$9,MOD($C6-1+0,$B$10)+1) gives Ravindra. Includes an example data table.
Card 1 of 2: Household Chores Roster in Excel · Download PNG
Read card text

What this card says

1 for Household Chores Roster in Excel: Number of members: =COUNTA(A6:A9) gives 4

Next week's start date: =D6+7 gives 05-10-2026

Who does chore 1 in week 1: =INDEX($A$6:$A$9,MOD($C6-1+0,$B$10)+1) gives Ravindra. Includes an

Example

data table

Learn this in the lesson: Household Chores Roster in Excel: Rotate Chores Every Week Automatically (INDEX and MOD)

See all Excel revision cards