Shop / Guides / Freelance day rate calculator
Guide · Freelancer pricing
Freelance day rate calculator in Excel
A day rate is not “hourly × 8 and hope.” It should start from the take-home you need, a tax cushion, and the billable hours you actually sell — then multiply by the hours you deliver in a workshop, shoot, or on-site day. Yellowcell’s free one-sheet calculator locks an hourly floor first, then day and half-day lines that match.
Lock the hourly floor first
- Target take-home — what you want to keep after business costs (annual or monthly; stay consistent)
- Tax cushion % — a rough buffer for income and self-employment tax (illustrative only; confirm with a preparer — not tax advice)
- Billable hours — weeks per year × hours per week you can honestly sell (admin, sales, and sick days do not count)
Gray cells turn those into required revenue and an hourly floor. Day and project quotes should hang off that number so they never contradict each other.
Day and half-day from the same sheet
| Cell role | Example |
|---|---|
| Yellow — billable hours in a full day | 6 (intensive client day; use 8 only if you truly bill eight) |
| Yellow — half-day length | 3–4 hours — not always “half of full” |
| Yellow — travel / setup buffer (optional) | Extra hours or a flat premium for on-site days |
| Gray — full day rate | hourly floor × billable hours in a day |
| Gray — half-day rate | hourly floor × half-day hours (or a fixed fraction you document) |
Numbers above are examples only. Replace every yellow cell with your own before you quote a client.
When a day rate beats pure hourly
- Workshops, shoots, installs, or travel days where context-switching kills true hourly tracking
- Clients who buy “a day of your attention” more cleanly than a pile of 0.25-hour lines
- You want a clear amount due on the invoice before scope starts drifting
Stay hourly when scope is fuzzy and change orders are frequent — but still derive the rate from the same floor so day and hourly quotes stay consistent.
Half-day and overtime traps
- Pricing half-days at 50% of a full day when fixed costs (travel, setup) are the same — undercharges the short booking
- Using 8 × hourly when you only deliver 5–6 focused hours
- Quoting a day rate then accepting “just one more hour” without an overtime rule
- Leaving “TBD” on the client PDF after the calculator already produced a fee
Get the free calculator
Yellowcell’s free client rate sheet covers hourly floor, day / half-day, and project fee from the same yellow inputs. No macros. Soft path into the invoice kit when you are ready to bill.
Put the day rate on an invoice
The calculator is for you. The client sees a clean invoice: deliverable (e.g. “On-site day — 6 billable hours”), quantity, rate, tax if any, amount due, and payment terms. Copy the locked day or half-day number into your invoice workbook so the quote and the bill match.