Why a day rate is not simply a salary divided by 260
If you leave a job and start working for yourself as a digital marketer (paid search, email, social content, reporting for small businesses), one number decides how the first year feels: the price you put on a day of your time. The tempting shortcut is to take the yearly income you would like, divide it by the 260 weekdays in a year and call the result your day rate. It looks tidy and it is wrong, because a freelancer is not paid for 260 days. Holidays, sickness, public holidays and training are unpaid, and a large part of the days that remain goes on work that no client pays for directly: answering enquiries, writing proposals, sending invoices, learning a new platform feature.
This free lesson builds the calculation properly in Excel, from a planning target to the day rate you would quote. It is planning arithmetic and nothing more: the target in the example is an assumption, not a promise of what a freelancer will earn, and the market decides what clients will pay. What the sheet gives you is a way to see how each assumption changes the price, so that a quote is never a guess. You can change the figures to your own and the whole chain recalculates.
The example is Yarrowby Studio, a fictional one-person marketing business. All names, clients and numbers in this lesson and in the whole course are invented for learning. You will use the same figures as in the lab above: 52 weeks in the year, 7 weeks off, 8 public holidays that fall on weekdays, a 60% billable share, a take-home target of £36,000, a 25% tax and pension reserve and six business cost lines.
The core concept: working days, billable days and the billable share
Start with the calendar. A year has 52 weeks, and with five working days a week that makes 260 weekdays. Subtract the weeks you do not work (here 7 weeks, so 35 days) and the public holidays that fall on weekdays (here 8) and you are left with the working days: (52 − 7) × 5 − 8 = 217. In Excel that is one formula, =(B4-B5)*B7-B6.
The next step is the one most newcomers skip. Not every working day can be invoiced. Some days go on finding the next client, writing a proposal that may never be accepted, doing the books or answering an email from a prospect who then disappears. The share of working days you can actually bill is the billable share. Many freelancers who track their time find it is well under 100%, and it often starts lower than expected because selling and admin work do not shrink just because you are busy. The example uses 60%, which is an assumption you replace with your own tracked figure as soon as you have one (lesson 11 shows how to get it from a timesheet).
The billable days are therefore 217 × 0.6 = 130.2 days a year. That is the number your price has to be spread over. A freelancer who divides by 217 instead charges as if every working day were billable, and will end the year with less money than planned even though every invoiced day was paid in full.
From a take-home target to the revenue you need
The second half of the calculation turns the target into money. The target of £36,000 is meant as take-home pay, what you can spend. But tax and pension contributions are paid out of profit, so to take home £36,000 you must earn more before they are deducted. If the reserve you set aside is 25% of profit, then the take-home pay is 75% of profit, and profit needed = target ÷ (1 − reserve) = 36,000 ÷ 0.75 = £48,000. The £12,000 difference is the tax and pension reserve. The rate and the rules depend on the country and your situation; the 25% here is only a placeholder, so ask an accountant for the real figure.
Business costs come on top. They are paid out of revenue before there is any profit, so they are added after the gross-up and not before it. Yarrowby Studio has six cost lines: software and tools (£1,320), accountant (£780), insurance (£420), a co-working desk (£1,800), equipment and phone (£650), and training and events (£540). In Excel the total is =SUM(E4:E9), which gives £5,510. The revenue needed before tax is then £48,000 + £5,510 = £53,510, written as =B9/(1-B10)+E10.
| Step | Calculation | Result |
|---|---|---|
| Take-home target | Planning assumption | £36,000 |
| Profit needed | 36,000 ÷ (1 − 0.25) | £48,000 |
| Tax and pension reserve | 48,000 − 36,000 | £12,000 |
| Business costs | SUM of six lines | £5,510 |
| Revenue needed | 48,000 + 5,510 | £53,510 |
The day rate: revenue divided by billable days
Now the two halves meet: day rate = revenue needed ÷ billable days = 53,510 ÷ 130.2 = £410.98, which you round to a whole pound with =ROUND(B14/B13,0). The result is £411 per day. With a 7.5-hour day that equals about £54.80 per hour, but remember that the hourly figure is only a way of expressing the day, not extra income: lesson 2 shows what happens when the hours outside client work are counted.
Compare it with the shortcuts
Look at what the common shortcuts would have produced for the same inputs. Dividing the take-home target by the billable days ignores tax and costs and gives £276.50 per day. Dividing the revenue needed by all 217 working days gives £246.59 per day. Both numbers are much lower than £411, and both would leave the freelancer short of the plan at the end of the year. This is why newcomers who price by feel often end up working a full calendar and still missing the target: the arithmetic of non-billable time and tax simply was not in the price.
Your own result will be different, and that is the point. A lower target, lower costs or a higher billable share all reduce the rate. The sheet lets you test each one separately. If the market in your area will not pay the resulting rate, that is also useful to know before you start, because the alternatives are to cut costs, to raise the billable share through better systems, or to change the target.
How the billable share changes the price
The billable share is the assumption with the biggest effect, so it deserves a closer look. Keep everything else as it is and try three values. At 50% there are 108.5 billable days and the rate is £493. At 60% (the lab) there are 130.2 days and the rate is £411. At 70% there are 151.9 days and the rate is £352. A ten-point change in the share moves the rate by roughly £60 to £80. That does not mean you should simply assume 70%: many freelancers spend more time on sales when work is thin, which is exactly when the share falls.
Step by step in Excel
- Type the labels and planning inputs in A4:B10 (weeks in the year, weeks off, public holidays, working days per week, billable share, take-home target, tax and pension reserve) and the six cost lines in D4:E9.
- Click B12 and type
=(B4-B5)*B7-B6for the working days. Press Enter; the result should be 217. - Click B13 and type
=B12*B8for the billable days (130.2). Format it with one or two decimals; a share of days is fine. - Click E10 and type
=SUM(E4:E9)for the business costs. SUM adds every number in the range you give it. - Click B14 and type
=B9/(1-B10)+E10. The brackets matter: the reserve is subtracted from 1 first, then the target is divided by that result. - Click B15 and type
=ROUND(B14/B13,0). ROUND(number, 0) rounds to a whole number, so the quote is a clean £411. - Change one input, for example the billable share in B8 to 0.7, and watch every result below it update. Then put the value back.
Common mistakes and how to spot them
- Forgetting the weeks off or the holidays.
=B4*B7gives 260 days. If the working days equal the number of weekdays, something is missing. - Treating all working days as billable. Dividing the revenue by B12 instead of B13 gives a rate that is far too low. Check that the divisor is smaller than the working days.
- Grossing up the costs.
=(B9+E10)/(1-B10)applies the tax reserve to costs that are paid before profit. Gross up only the target, then add the costs. - Ignoring the tax and pension reserve.
=B9+E10gives £41,510, which is £12,000 too little. Compare the result with the profit needed of £48,000. - Brackets in the wrong place.
=B9/1-B10+E10divides first and then subtracts 0.25, so the reserve barely changes the result (about £41,510 instead of £53,510). If the revenue needed is only a little above the target plus the costs, the brackets are wrong. - Forgetting to round. A quote of £410.98 looks odd. ROUND to a whole pound, or to the nearest £5 if you prefer round numbers.
How to read the result
A day rate is not a price list. It is the minimum average income per billable day that makes the plan add up. Some days you will sell at more, some projects will be fixed fees that take longer than expected, and some clients may pay less because the work is smaller or they refer you to others. That is why the rest of the course turns the day rate into package prices, tracks the effective rate you really earn and checks it against the plan.
Use the result as a comparison tool. If you are offered a project at £300 per day and your plan needs £411, you know the project does not cover the plan unless you plan to be much busier or lower your costs. If a prospect asks for a discount of 10%, you can calculate what it does to the year. A freelancer who knows the arithmetic can say yes or no with a reason.
Quick reference: functions and formulas in this lesson
| Function / formula | What it does here | Example |
|---|---|---|
| Working days | Weeks worked × days per week − holidays | =(B4-B5)*B7-B6 |
| Billable days | Working days × billable share | =B12*B8 |
SUM | Adds the business cost lines | =SUM(E4:E9) |
| Gross-up | Target ÷ (1 − reserve) + costs | =B9/(1-B10)+E10 |
ROUND | Rounds the day rate to a whole pound | =ROUND(B14/B13,0) |
| Absolute reference | Dollar signs keep a cell fixed when you copy | $B$10 |
Real-world uses
- Quoting a first client. Work out the day rate before the first call, so that the answer to "what do you charge?" is not improvised.
- Deciding on a career move. Compare the required day rate with what clients in your market pay for the same work before you give up a salary.
- Reviewing prices every year. Update the costs, the weeks off and the billable share, and see whether the day rate still holds.
- Testing an offer. Change one input, such as a cheaper desk or fewer training days, and see how much the rate moves.
- Explaining prices to clients. Not by showing them your sheet, but by being confident that your price is a number with reasons behind it.
What you will build in the rest of this course
Lesson 1 gave you the rate. The remaining 19 labs follow the working life of a solo freelance digital marketer, from pricing to selling, delivering, getting paid and managing risk. Each one uses a new data set from Yarrowby Studio, and each one adds a spreadsheet skill.
Hourly vs Effective Rate: eight weeks of time and fees show what non-billable hours do to the rate per hour worked. Package Pricing: hours, a revision buffer and MROUND turn work into clean prices. Proposal Win Rate and Win Rate by Source count wins with COUNTIF and compare referrals, enquiries, outreach and marketplaces. Expected Value of a Proposal: what a proposal is worth per hour of selling time and the break-even win rate. The Weighted Pipeline: stage chances and coverage of a fee goal. Sales Cycle: days from enquiry to decision and follow-up dates.
Estimate vs Actual Hours and Scope Creep track overruns and the price of unbilled changes. Timesheet Analysis gives the billable share from real entries. Retainer vs Project Income and Retainer Tiers compare income types and price included hours and overage. Invoices and Payment Terms follows due dates and late payers. Client Concentration and Losing the Largest Client measure dependence and replacement work. Capacity Planning checks that promised hours fit. Slow Months and Cash Buffer forecasts a trend. Price Rise What-If builds a scenario grid, and the final project is a quarterly review with a combo chart.
Summary
A day rate starts with the calendar, not with the target. Working days are =(B4-B5)*B7-B6, billable days are working days times the billable share, and the revenue needed is the target grossed up for the tax reserve plus the business costs. Dividing that revenue by the billable days and rounding gives the day rate. For Yarrowby Studio the chain is 217 working days, 130.2 billable days, £53,510 of revenue and a day rate of £411. Because every input is an assumption, the same sheet answers the questions that follow in the real world: what happens if I bill less, spend less or aim lower?
Now scroll up to the lab and build the sheet yourself. It takes about fifteen minutes, the Coach checks each step, and you will end with a rate calculation you can adapt to your own situation.
Frequently asked questions
How do I calculate a freelance day rate in Excel?
Calculate the working days (weeks worked times days per week minus public holidays), multiply by the billable share to get the billable days, and divide the revenue you need (take-home target grossed up for tax, plus business costs) by the billable days. In Excel that is a chain of simple formulas that you can change at any time.
Why is my day rate higher than my salary divided by 260?
Because you are not paid for weekends, holidays or sickness, and many working days go on sales, admin and learning that clients do not pay for directly. Tax, pension and business costs also come out of what you invoice. The extra amount in the day rate pays for all of that.
What is a billable share?
The billable share is the part of your working days (or hours) that you can invoice to clients. The rest is non-billable time, such as proposals, invoicing and training. A timesheet kept for a few weeks shows the real figure, and the day rate depends on it strongly.
Should I use the same tax reserve as shown in the course?
No. The 25 percent in the lab is a placeholder for planning. Tax and pension rules depend on the country, the business form and your situation, so ask a qualified adviser for the reserve that applies to you.
Does the day rate guarantee that I will earn the target?
No. It is arithmetic based on assumptions: how many days you work, how many you can bill and what your costs are. Clients decide what they pay, and demand varies. Use the rate for planning and quoting, not as a forecast of income.
Can I use this lab for an hourly rate?
Yes. Divide the day rate by the hours in a billable day, or build the same chain with hours instead of days. Lesson 2 compares the quoted hourly rate with the effective rate you earn per hour worked.
Keep going: Freelance Digital Marketer: Day Rates, Package Pricing, Proposal Win Rate, Pipeline, Scope & Hours, Retainers and Client Concentration
This free lab is lesson 1 of 20. Unlock the other 19 hands-on labs, the final exam and your certificate for a one-time $9.90.
- Hourly Rate, Day Rate and Effective Rate: What Non-Billable Hours Do to What You Earn
- Package Pricing: Hours, Hourly Rate, a Revision Buffer and Clean Round Prices
- Proposal Win Rate: Counting Won, Lost and Pending, Decided Proposals and the Value You Win
- Win Rate by Lead Source: Referrals, Enquiries, Outreach and Marketplaces Compared
- Expected Value of a Proposal: Win Rate × Fee, Pay per Selling Hour and the Break-Even Win Rate
- The Client Pipeline: Stages, Chance of Winning, Weighted Value and Coverage of a Fee Goal
- Sales Cycle: Days from Enquiry to Proposal to Decision and Follow-Up Dates
- Scope and Hours Tracking: Estimate versus Actual, Overrun and the Effective Rate per Project
- Scope Creep: Logging Change Requests, Billed and Unbilled Out-of-Scope Hours and What They Cost
- Timesheet Analysis: Hours by Task Type, Share of Time, Rank and Billable Share
- Retainer vs Project Income: Monthly Totals, Retainer Share and a Moving Average
- Retainer Tiers: Included Hours, Overage Charges and the Effective Rate per Client
- Invoices and Payment Terms: Due Dates, Days Late, Open Invoices and Reminders
- Client Concentration: Share of Fees, Rank, the Top Three and a Concentration Index
- What If the Largest Client Leaves? Lost Fees, Replacement Projects, Proposals and Selling Hours
- Capacity Planning: Billable Hours, Committed Retainer and Project Hours, Spare Time and Utilisation
- Income Forecast and Slow Months: Trend, FORECAST.LINEAR, Shortfalls and a Cash Buffer
- Price Rise What-If: A Scenario Grid of Price Increases and Lost Clients with Mixed References
- Final Project: A Quarterly Review of Hours, Effective Rate, Win Rate and Client Dependence