Trying to add up how many days you spent somewhere across a whole year is fiddly, and it gets worse when trips cross New Year. One miscounted week can throw off a visa tally, a tax residency check or a travel summary. Paste your trips below as start and end dates, and the Days Per Year Calculator splits every range into the exact days that fall in each year or month — no spreadsheet, no manual counting.
Paste one date range per line, like 2024-12-20 to 2025-01-05. You get the number of days in each year (or month), even when a trip crosses New Year. Everything runs in your browser; nothing is uploaded.
The result appears here.
Why counting days per year by hand goes wrong
Most people start with a simple subtraction: end date minus start date. That falls apart quickly. Ranges that cross 31 December need splitting by hand, leap years add a day in February, and it is easy to forget whether the first and last days both count.
It gets messier with several trips. You might count the same overlapping days twice, or lose track of which year a long Christmas-to-January trip belongs to. The longer the list, the more the small slips add up.
This Days Per Year Calculator removes the arithmetic entirely. It reads each range you paste, counts the days with the rule you choose, and groups them by year or by month so the split across New Year is handled for you.
How to use the Days Per Year Calculator
Using the calculator takes less than a minute. Type or paste one date range per line into the box, using a start date, the word “to”, and an end date, for example 2024-12-20 to 2025-01-05.
Next, choose your date format so the tool reads day and month in the right order: YYYY-MM-DD or DD/MM/YYYY. Then pick the counting rule that matches what you need, such as counting both the start and end day.
Choose whether to group the results by year or by month. If any of your ranges overlap, leave “Count overlapping days only once” ticked so shared days are not counted twice. Press the button and the result table appears below.
Choosing how days are counted
The counting rule matters more than it looks. Some tallies count both the arrival and departure day, others count only the nights between them. The days per year calculator lets you choose the rule up front, so every range in the list is measured the same way.
The overlap option is just as important. Back-to-back trips sometimes share a boundary day, and rebooked holidays can overlap by a week. Counting overlapping days only once keeps the totals honest instead of inflating them.
Switching between year and month grouping is useful too. Year totals suit residency and visa questions, while month totals show the rhythm of your travel — handy when you want to see which months carried the most days away.
Worked example: a trip across New Year
Suppose you travelled from 20 December 2024 to 5 January 2025, and again from 10 March 2025 to 24 March 2025. Entered as two lines — 2024-12-20 to 2025-01-05 and 2025-03-10 to 2025-03-24 — with the rule “start day and end day both count”, the calculator splits the first trip into 12 days in December 2024 and 5 days in January 2025.
The second trip adds 15 days to March 2025. Grouped by year, the result reads 12 days for 2024 and 20 days for 2025, with a total of 32 days. Nothing is double counted, and the New Year split is exact.
Click “Load example” in the tool to try a ready-made set of ranges, then change the grouping to Month to see the same trips broken down into December, January and March.
Copying your results into Excel or Sheets
Once the table looks right, use “Copy for Excel / Sheets” to drop the results straight into a spreadsheet, or “Copy as CSV” for a plain-text version you can save anywhere. The totals keep their layout, so you can file them with a visa application or a travel log.
If your raw data mixes numbers with words — for example “12 days” copied from a booking email — the Split Numbers and Units tool separates the figures from the text first. And if you later build formulas on the exported table, the Bulk Formula Reference Locker fixes the cell references in bulk.
Planning more number formats for that spreadsheet? The Excel Custom Number Format Generator creates format codes that show units like “days” or “kg” next to your numbers without breaking the sums underneath.
Please note: this tool only counts days
The Days Per Year Calculator counts the days between the dates you enter, and nothing more. It is not tax advice and not visa or immigration advice. Residency rules differ by country, and many depend on more than a day count, such as ties, domicile or the exact legal definition of a day.
Always check the official rules for your situation and confirm the counting method with a qualified adviser before relying on the totals for anything official. The tool gives you an accurate count; what the count means is up to the rules that apply to you.
Days per year calculator FAQs
How do I count days outside a country per year?
List each trip outside the country as one line with its start and end dates, choose the counting rule that matches the scheme you are checking, and group by Year. The days per year calculator adds up every trip’s days into yearly totals, splitting any trip that crosses New Year between the two years.
Is the start or end day counted?
That depends on the counting rule you select. The default rule counts both the start day and the end day, so a trip from 1 March to 3 March counts as 3 days. If your scheme counts differently, choose another rule before calculating — the key point is that every range uses the same rule.
Can I use this for visa or tax residency?
You can use it to get an accurate day count to work from, but the tool only counts days from the dates you enter and does not interpret any visa or tax rules. Those rules vary by country and often involve more than a day total, so treat the result as a starting figure and check the official guidance or an adviser for your case.