Two ways to work with dates
Most date questions fall into one of two shapes. Either you know two dates and want the distance between them, or you know one date and an offset and want the date that lands at the other end. This tool handles both. The first mode measures a span; the second mode moves a date. Both understand weekends and an optional list of holidays, so you can work in calendar days or in business days.
Days between two dates
Enter a start date and an end date. The result is shown three ways: as years, months and days; as weeks and days; and as a single number of calendar days. By default the count excludes the end date, the same way you would say there is one day between Monday and Tuesday. Tick include end day if both the first and the last date should count, as you would for a hotel stay counted in nights plus one, or for an event that runs from the 3rd through the 7th.
How months are counted
Months have different lengths, so "one month" is measured from a date to the same day number in the next month. When that day does not exist, the calculation uses the last day of the shorter month. For example, one month after January 31 is February 28 (or 29 in a leap year). The leftover is then counted in plain days.
Weeks = floor(total ÷ 7), remaining days = total mod 7
Weekend days, holidays and business days
Within the span, every Saturday and Sunday is counted as a weekend day. Any selected holiday that falls in the span is counted as a holiday. Business days are the remaining days: total days minus weekend days minus holidays. Holidays are counted on their actual date. If a holiday such as Independence Day lands on a Saturday it is still counted as a holiday, which means it is subtracted twice; this matches how many simple spreadsheet business-day counts behave, and you can untick that holiday if your employer observes it on a different day.
Add to or subtract from a date
Pick a start date, choose add or subtract, and enter any mix of years, months, weeks and days. Years and months are applied first using the month-end rule above, then weeks and days are applied as exact day counts. Adding 1 year, 1 month, 2 weeks and 3 days to January 31, 2026 gives February 28, 2027 after the year and month step, and March 17, 2027 after the remaining 17 days.
Business-day mode
Tick calculate in business days to step only over working days. In this mode only the days box is used. Counting starts on the start date itself: if the start date is a working day it counts as the first business day, and the result is the first date after the required number of business days has passed. Subtraction works the same way in reverse. With holidays excluded, adding 10 business days to Sunday, December 20, 2026 skips Christmas and New Year's Day and lands on Wednesday, January 6, 2027.
Worked example
From January 15, 2026 to November 3, 2026 there are 9 months and 19 days, which is 41 weeks and 5 days, or 292 calendar days. That span contains 84 weekend days. With the standard US federal holidays selected, 7 holidays fall inside it (M. L. King Day, Presidents' Day, Memorial Day, Juneteenth, Independence Day, Labor Day and Columbus Day), leaving 201 business days.
US holidays used
| Holiday | Rule |
|---|---|
| New Year's Day | January 1 |
| Martin Luther King Jr. Day | Third Monday in January |
| Presidents' Day | Third Monday in February |
| Memorial Day | Last Monday in May |
| Juneteenth | June 19 |
| Independence Day | July 4 |
| Labor Day | First Monday in September |
| Columbus Day | Second Monday in October |
| Veterans Day | November 11 |
| Thanksgiving | Fourth Thursday in November |
| Black Friday | Day after Thanksgiving (optional) |
| Christmas Eve, Christmas, New Year's Eve | December 24, 25 and 31 |
You can also add up to three custom holidays that repeat on the same month and day every year, such as a company founding day or a local observance.
A short history of the Gregorian calendar
The calendar used here is the Gregorian calendar, introduced in 1582 to fix drift in the older Julian calendar. The Julian system added a leap day every four years, which made the average year about 11 minutes too long. Over centuries the spring equinox slid earlier on the calendar. The Gregorian reform keeps the four-year leap rule but skips leap years in century years unless the year is divisible by 400. So 2000 was a leap year but 1900 was not. The result is an average year of 365.2425 days, close enough to the solar year that the error is about one day every 3,000 years. All calculations here use this proleptic Gregorian calendar for every year you enter.