Stages
Just playMission 1/6
Two dates, one is text
- Column A shows each day as words; column G holds it as a number.
- Ask both columns for a month and compare.
Do thisMission 2/6
A month on every row
Do thisMission 3/6
Add up one month's sales
Do thisMission 4/6
Which year, and how long
Do thisMission 5/6
Month and year per row
Do thisMission 6/6
Reach the log's last row
★★★
Run cleared.
🚀 Push it
- 🟢Add a line that counts the rows from the month before.
- 🟡Point the question cell at a month with no sales and read the answer.
- 🔴Explain why this lab needs the date value column when Google Sheets does not.
🌐 Make it for real
Open a blank spreadsheet in Google Sheets and build the sample sales log with its month column.
Twist: move the last sale into the next month and check that its month follows.
🧑🏫 Teacher Guideclick to open
⏱ 53015
✅ Watch for
- Month numbers typed down the column by hand
- MONTH pointed at the written date, which this lab keeps as text
- Months pasted as values that ignore a changed date