By the end of June, about half the year is gone. More precisely, it’s 49.6%, and the year’s exact halfway point in a normal year lands at noon on July 2. By the end of September you’ve used up almost three-quarters (74.8%). Numbers like these are why “what percent of the year has passed?” is such a popular search: a percentage makes the year feel real in a way a date doesn’t.
Here’s the formula, a month-by-month table you can bookmark, and how to calculate it for any date in Excel or Google Sheets.
The Formula
Percent of year passed = (day of the year ÷ days in the year) × 100
The “day of the year” counts January 1 as day 1 and December 31 as day 365 (or 366 in a leap year). This version counts a date as fully finished, which is how most people think about it: at the end of January 31, 31 days are done.
Example: September 23, 2026 is day 266 of 365. 266 ÷ 365 = 0.7288, so about 72.9% of 2026 has passed by the end of that day, and 27.1% is left.
Once you know the day number (the table below gets you close, then add the days into the current month), drop it and the year length into the “X is what % of Y” box on our Percentage Calculator.
How Much of the Year Has Passed at the End of Each Month
| End of… | Day of year | % passed (normal year) | % passed (leap year) |
|---|---|---|---|
| January | 31 | 8.5% | 8.5% |
| February | 59 (60 in leap years) | 16.2% | 16.4% |
| March | 90 (91) | 24.7% | 24.9% |
| April | 120 (121) | 32.9% | 33.1% |
| May | 151 (152) | 41.4% | 41.5% |
| June | 181 (182) | 49.6% | 49.7% |
| July | 212 (213) | 58.1% | 58.2% |
| August | 243 (244) | 66.6% | 66.7% |
| September | 273 (274) | 74.8% | 74.9% |
| October | 304 (305) | 83.3% | 83.3% |
| November | 334 (335) | 91.5% | 91.5% |
| December | 365 (366) | 100% | 100% |
2026 and 2027 are normal 365-day years; 2028 is the next leap year.
When Is Exactly Halfway Through the Year?
In a normal year, 365 ÷ 2 = 182.5 days. After July 1 ends, 182 days have passed, so the true midpoint is noon on July 2. In a leap year the halfway point is 183 days, which falls exactly at midnight between July 1 and July 2.
Quarters don’t split the year evenly either. Q1 (January to March) is only 90 days in a normal year, while Q3 (July to September) and Q4 (October to December) are 92 each. That’s why “end of Q1” is 24.7% rather than a neat 25%.
How to Calculate It in Excel or Google Sheets
With a date in cell A1, this works in both Excel and Google Sheets and handles leap years automatically:
=(A1-DATE(YEAR(A1),1,0))/(DATE(YEAR(A1)+1,1,1)-DATE(YEAR(A1),1,1))
Format the cell as a percentage. DATE(YEAR(A1),1,0) is a handy trick: day zero of January is December 31 of the previous year, so subtracting it gives the day-of-year number. For today’s date, replace A1 with TODAY().
For the percentage remaining, subtract the result from 1: =1-(the formula above).
Other “Year Progress” Calculations People Need
Fiscal years. If your fiscal year runs April to March (common in the UK) or October to September (the US federal government), count days from your fiscal start date instead of January 1. The division is the same.
Working days instead of calendar days. A budget or sales target is usually tracked against business days, not calendar days. With about 261 weekdays in a typical year, the halfway point by working days can differ from July 2 by a few days depending on holidays. The Business Days Calculator counts weekdays between two dates and can exclude public holidays.
Pro-rating. The same percentage is how annual amounts get pro-rated: a $1,200 annual subscription cancelled at the end of March has used 24.7% of the year, about $296.
Why It’s Worth Knowing
Percent-of-year is a quiet but useful gut check. If it’s the end of September and you’re 40% of the way to an annual goal, you’re behind a 74.8% pace. It’s the reasoning behind the “year progress” bots that post updates like “The year is 75% complete,” and it’s the easiest way to sanity-check a budget, a reading goal or a savings plan against the calendar.
Frequently Asked Questions
What percent of the year has passed by July 1?
At the end of July 1, 182 of 365 days have passed, which is 49.9% in a normal year. In a leap year it’s 183 of 366, exactly 50%.
What day is 75% through the year?
In a normal year, 75% is 273.75 days, which falls during October 1 (September ends at 74.8%).
What day is 25% through the year?
25% of 365 is 91.25 days. The end of March is day 90 (24.7%) and the end of April 1 is day 91 (24.9%), so the quarter mark arrives early on April 2 in a normal year.
How do I work out what percent of the month has passed?
Divide today’s date by the number of days in the month. On the 15th of a 30-day month, 15 ÷ 30 = 50% has passed.
Need to turn any two numbers into a percentage? The Percentage Calculator does “X is what % of Y” instantly as you type.