How to Track How Many Days You've Spent in Each Country

If you live across borders, you carry a running number in the back of your mind: how many days have I been here? It sounds small until you try to do it properly. Then the rules disagree with each other, the days you thought were free turn out not to be, and the one tool everyone reaches for quietly breaks. This is a calm walk through how day counting actually works, what each method is good and bad at, and how to choose the one that fits your life. If the counting itself weighs on you, I wrote about that quiet anxiety separately.

Who actually needs to count

Day counting turns up in more places than people expect, and each one counts for a different reason:

• The Schengen 90/180 rule, if you visit Europe on a visa waiver.
• Tax residency, where the 183-day rule and its national variants decide where you owe tax.
• Visa conditions that limit how long a single stay can last.
• Citizenship or settlement applications that cap how many days you can be absent.

Different consequences, one shared need: a day count you can trust.

Why day counts are harder than they look

Three things trip people up. The first is the window. Some rules count against a fixed calendar year that resets cleanly; others count against a window that moves with you. Schengen is the hard one: it looks back over a rolling 180 days, so there is no annual reset, and leaving does not wipe the slate.

The second is the edges. Under many day-counting rules, the day you arrive and the day you leave each count as a day of presence, even if you were only there for part of it. The exact treatment depends on the rule you are dealing with, but across a year of short trips those edge days add up to far more than people guess.

The third is that the rules disagree. The number that makes you a Schengen overstayer is not the number that makes you a tax resident, and neither is the number a citizenship office cares about. One trip can count toward several limits at once, measured differently by each.

Method one: the spreadsheet, and where it breaks

The spreadsheet is where almost everyone starts, and for a plain history of trips it is fine. You type in your arrival and departure dates and see it all at a glance.

It breaks at the counting. A rolling window is genuinely hard to put in a formula: for every single day you have to look back 180 days, add up the ones you were inside, and keep that working as the window slides. Most homemade spreadsheets get it subtly wrong or quietly stop being kept up. Nothing warns you before a planned trip tips you over, and one mistyped date corrupts the total without a sound. A spreadsheet records your days. It does not really watch them for you.

Method two: automatic GPS apps

At the other end are apps that track your location in the background and infer which country you are in. When they work, they feel effortless: you count nothing, and the log fills itself.

The tradeoffs are real. Background location costs battery, and it means trusting an app with a continuous record of everywhere you go. The data is noisy, too: a layover, a day trip across a border, or a GPS glitch can log a country you never really visited, and you have to go back in and fix it. Automatic sounds hands-off, but for anything that matters you end up checking its work anyway.

Method three: record stays, not pings

There is a middle path: record the stays rather than the pings. Instead of tracking your coordinates, you note where you are living for a stretch and for how long. It is deliberate, it is private, and because you entered it yourself, you trust it.

This is the model I built Sojourn around. You keep a record of your stays, and the counting sits on top of that, without a tracker following you around. It is the same instinct as the old passport stamp, a small record you can read, made to actually do the arithmetic. I wrote more about why I built it in A Year You Can Hold.

The goal is not to track every second of your life. It is to keep a record you can understand and trust.

Which method fits you

If you just need a one-off answer for a single Schengen trip, you do not need a system at all. Open the Schengen calculator, enter your stays, and read off the days you have left.

If you take a handful of trips a year and like doing things by hand, a spreadsheet can hold it, as long as you are honest that you are the one doing the watching.

If you are moving constantly, or several rules apply to you at once, the manual work stops being worth it. That is the point where recording your stays somewhere that counts for you becomes the calmer choice.

One thing worth saying plainly: keeping a good day count helps you organize and understand your own movement. It is not legal or tax advice. For Schengen, the authoritative record is now the border's own biometric system, and tax residency has tests that reach well beyond counting days. Keep your count as a planner and a cross-check, and for anything with real stakes, talk to a professional who does this for a living.

Common questions

What is the best way to track days spent in each country?

There is no single best way, only the one that matches how much you move. For a one-off check, a calculator is enough. For occasional trips, a careful spreadsheet can work. For constant movement or overlapping rules, recording your stays in something that does the counting saves the most grief.

Is a spreadsheet enough for the Schengen 90/180 rule?

It can be, but only if its formula correctly handles the rolling 180-day window, which is exactly the part most spreadsheets get wrong. If you are not certain yours is right, check the result against a dedicated calculator before you rely on it.

Can an app track my days automatically?

Yes. GPS apps can log your location in the background and infer countries, but the data is noisy and costs battery and privacy, so you will still want to review and correct it before trusting the total for anything important.

Do arrival and departure days both count?

Under many rules, yes. The day you arrive and the day you leave often each count as a full day of presence, even partial ones. The exact treatment depends on the rule, but across many short trips this is the most commonly underestimated part of a day count.