Stages
Just playMission 1/5
Let the sheet know the date
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Store dates as numbers
Do thisMission 3/5
Ask the sheet for today
Do thisMission 4/5
Count each order's waiting days
Do thisMission 5/5
Rules that read the Today cell
★★★
Run cleared.
🚀 Push it
- 🟢Add a fourth order and let it count its own days.
- 🟡Count the days until an exam.
- 🔴Explain why a date is really a number.
🌐 Make it for real
Open a blank Google Sheet and build the sample order sheet from an empty grid.
Twist: open it again tomorrow and check that every count went up by one.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Dates typed as text instead of day numbers
- Day counts worked out on a calendar and typed
- Today's date typed in, so the counts never move