Activity Log: Weekly Walk and Play Minutes with ISOWEEKNUM and SUMIFS
This lesson is part of the course
In this lesson
You add ISO week numbers to three weeks of Pepper's activity entries, total walk and play minutes per week with SUMIFS, compare each week with the family's goal and work out the average per calendar day.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Weight Log: Weekly Gain in Grams and Percent, Average Daily Gain Locked
- Estimating Adult Weight: Size Classes and Multipliers with XLOOKUP Locked
- Growth Chart: Above/Below Flags Against a Reference Band and a Line Chart Locked
- Body Condition Score Log and the Implied Target Weight Locked
- Age in Human Years: A Linear Rule vs a Log Formula with LN Locked
- The Care Calendar: Next Due Dates with EDATE, Days Left and Overdue Flags Locked
- Activity Log: Weekly Walk and Play Minutes with ISOWEEKNUM and SUMIFS Locked
- Capstone: A One-Screen Pet Health Dashboard Locked