Settings

Between two dates

“Days between” means two things. A notice period counts the days that pass; a hotel booking counts the days involved. Both are here because the difference is one day and it is always the day that matters.

Which days are not working days

The list has to be yours. Public holidays differ by country, by region within a country, and by year, and any software that shipped a list would be wrong for most of the people using it.

Add to a date

Age

The working


    
How it works

DATES does date arithmetic and writes down the awkward parts. Three months from 31 January has more than one answer, and days between can mean two different things, so it shows both and says which rule it used. Add or subtract days, weeks, months and years, count business days, and see the reasoning behind every result. It runs in this tab.

The guide: What “days between” actually means

Questions people ask about DATES

Why two answers for days between?

Because the question has two meanings. From Monday to Wednesday is two days that pass and three days involved. Notice periods, interest and ages count the first; bookings, custody clocks and inclusive statutory periods count the second. Giving one number and hoping is how a deadline is missed by exactly one day.

What happens adding a month to the 31st?

It clamps to the last day of the target month (31 January plus one month gives 28 February), and the page says that it clamped. The other common behaviour is to roll forward into March. Both are defensible, they disagree, and the only unacceptable thing is not saying which you did.

Why no built-in holiday list?

Because there is no such thing as the holiday list. They differ by country, by region within a country, by year, and by whether your organisation observes them. A list shipped in software would be quietly wrong for most people, which is worse than no list at all.

What is an ISO week?

The week numbering where week 1 is the one containing the year’s first Thursday, and weeks run Monday to Sunday. It is why the 1st of January is frequently in week 52 or 53 of the previous year, which surprises people every January and is not a bug.

Doing this often? In a law practice, OBSCURA Practice keeps every matter's deadlines with the matter, with reminders and a calendar file. Everything is US$5 a month or US$48 a year.