Recurring dog-walk clients pay monthly but book weekly. Multiply walks per week by 4.33 (the average weeks in a month) and your per-walk price for a steady monthly bill.
3 walks a week at $20 bills about $259.80 a month — smooth and predictable for both sides.
The example
Three clients with a weekly walk count and a per-walk price.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Client | Walks / week | Price / walk | Monthly |
| 2 | Bella | 3 | $20 | $259.80 |
| 3 | Max | 5 | $18 | $389.70 |
| 4 | Luna | 2 | $25 | $216.50 |
The formula
4.33 converts weekly to monthly:
How it works
The 4.33 is the key trick:
B2is the number of walks per week for that client.4.33is the average number of weeks in a month (52 weeks / 12 months).- Multiplying by
C2, the price per walk, gives the monthly amount;ROUND(…,2)keeps it to whole cents.
For exact billing, count the actual walks delivered that month instead of the 4.33 average.
Try it: interactive demo
Enter walks per week and the price per walk.
Variations
Bill actual walks
For exact months, multiply the real walk count by the price.
Pitfalls & errors
4.33 is an average; some months have more or fewer walk days. Reconcile against actual counts if clients ask.
Round to two decimals or the invoice can show a long decimal like 259.7999.
Practice workbook
Frequently asked questions
Why 4.33 and not 4?
What if a month has extra walk days?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class