How Many Days Are There Between Dates? Calculator & Guide

Ever stared at a calendar and wondered exactly how many days stretch between two dates — maybe from a birthday to a holiday, or from now until a deadline? It’s a simple question that trips up more people than you’d expect, because the answer depends on whether you count weekends, holidays, or the start day itself. This guide breaks down the methods, tools, and formulas that make day counting foolproof, so you never have to guess again.

Days in a common year: 365 ·
Days in a leap year: 366 ·
Basic formula: End date – Start date ·
Working days per year (5-day week): ~260 ·
Days between August 1 and December 31 (non-leap): 153

Five key measurements define the landscape of date arithmetic:

The pattern: every date calculation starts from a baseline system that balances celestial cycles with human convenience.

How do I calculate days between two dates?

Manual calculation

1. Subtract the start date from the end date. For example, from August 1 to December 31 in a common year: 153 days (GigaCalculator).
2. Decide whether to include the start day. Omni Calculator lets users choose this – including the end date adds one day to the count.
3. Adjust for leap years when crossing February 29. A leap year adds one extra day every four years, except century years not divisible by 400 (Time and Date).

The trade-off: manual counting is free and works offline, but mistakes are easy when months have different lengths.

Using online calculators

• Free online tools like GigaCalculator and Omni Calculator handle leap years and inclusive/exclusive modes automatically.
• Some calculators also support adding business days to a date, not just counting days between two dates (GigaCalculator).
• Planetcalc accounts for weekends, holidays, and weekend shifts.

In Excel / Google Sheets

• Excel’s DATEDIF function returns the difference in days, months, or years. To count all days between two dates, use =DATEDIF(start, end, "d") (Microsoft Support).
• Google Sheets offers DAYS(end, start) for a simple day count (Google Help).
• For working days, NETWORKDAYS automatically excludes weekends and optional holidays (Microsoft Support). NETWORKDAYS.INTL lets you specify which days are weekends (Microsoft Support).

What this means: spreadsheets are the workhorses of date math, but the DATEDIF and NETWORKDAYS functions count differently – one measures elapsed dates, the other filters weekdays.

How many days gap is there between?

Examples between specific dates

• How many days between August and December? In a non-leap year, from August 1 to December 31 is 153 days (counting all days). If you count only business days (Mon–Fri), it drops to about 109 days.
• From January 1 to December 31 in a common year: 365 days. In a leap year: 366 days.
• From today to your next birthday: use an online date duration calculator.

The pattern: the gap changes with leap years, inclusive settings, and whether you count weekends.

Counting days until a future event

• To count days until a deadline, decide whether the start or end date is counted. Most project management tools count all calendar days and then subtract non-working days.
• For “days since” a past event, the same logic applies – the number of days that have elapsed since a specific date.

The implication: inclusive/exclusive settings and leap years make calendar-span calculations context-dependent.

How do I calculate working days between two dates?

Excluding weekends

• Working days are Monday through Friday in most business contexts. Microsoft Support confirms that NETWORKDAYS excludes weekends by default.
• Omni Calculator offers three modes: include all days, exclude weekends, or exclude only Sundays.
• WorkingDays.us shows a dedicated calculator that also computes work hours.

Excluding holidays

• GigaCalculator supports official holiday calendars for the US, UK, Canada, and Australia (GigaCalculator).
• The NETWORKDAYS.INTL function allows a list of holiday dates as an optional parameter (Microsoft Support).
• Which days are considered holidays varies by country and organization – always confirm with an official local calendar.

Using online working day calculators

• GigaCalculator and Omni Calculator both let you input start and end dates and instantly get business days.
• Indy offers two separate tools: one for counting working days between dates and one for finding an end date from a start date plus workdays.
• Planetcalc also takes weekend shifts into account, useful for non‑standard work weeks.

The catch: business day counts vary dramatically by region – Monday may be a working day in the US but a public holiday in another country. Always check the calculator’s default holiday list.

How many days are there between 1 year?

Days in a common vs leap year

• A common year has 365 days; a leap year has 366. The extra day is February 29 (Time and Date).
• The average length of a year in the Gregorian calendar is 365.2425 days – this decimal is why leap years exist.
• Leap years occur every year divisible by 4, except century years not divisible by 400. So 1900 was not a leap year, but 2000 was (Time and Date).

Days between two years

• To count days between January 1 of one year and January 1 of the next, simply add the days of the year: 365 or 366.
• For example, from January 1, 2024 (leap year) to January 1, 2025: 366 days.
• When crossing multiple years, use an online date duration calculator or spreadsheet to sum the days accurately.

The implication: one year is never just “a year” – the 0.2425-day discrepancy means that any multi‑year calculation must account for leap cycles.

What is a Julian day?

Julian day number system

• The Julian day is a continuous count of days since the beginning of the Julian period, which started on January 1, 4713 BC (Wikipedia).
• Astronomers use Julian days to avoid the complexities of calendars – a single number represents any date and time as a decimal.
• The American Astronomical Society notes that the Julian date system is fundamental for coordinating observations across centuries and time zones.

Conversion to Gregorian date

• To convert a Julian day number to a Gregorian date, use online converters or spreadsheet functions like DATE with adjustments.
• The National Institute of Standards and Technology publishes official algorithms for conversion.
• Julian dates are also used in historical research, where dating events across different calendar systems requires a common reference point.

“The Julian day number system is essential for astronomical calculations because it eliminates month‑length variations and provides a continuous, uniform time scale.”

— Wikipedia

The trade-off: Julian days are precise but not intuitive – converting back to a familiar date takes a separate step.

Is it normal to have a 2 week gap between periods?

Cycle length variation

• An average menstrual cycle is 28 days, but it can range from 21 to 35 days in adults (NHS).
• A 14‑day gap between periods is shorter than the typical cycle. Cycles outside 21–35 days may indicate irregular ovulation.
• Factors like stress, weight changes, or hormonal disorders can cause temporary shortening.

When to consult a doctor

• If gaps between periods consistently fall below 21 days or exceed 35 days, or if you experience sudden changes, consult a healthcare provider (Mayo Clinic).
• A two‑week gap by itself is not necessarily a cause for alarm, but tracking over several cycles helps identify patterns.

The pattern: cycle length tracking is essential; a persistent 14-day gap warrants medical consultation.

“NETWORKDAYS returns the number of whole working days between start_date and end_date. Weekends are automatically excluded, and you can optionally exclude a list of holidays.”

— Microsoft Support

“A working-days calculator can determine the number of working days between two dates, often with options to exclude weekends and official holidays.”

— GigaCalculator

For anyone who regularly sets deadlines, plans travel, or tracks health, the difference between “days between” and “working days between” is not academic – it’s a practical filter that determines whether your schedule aligns with reality. Use the right method for your context: calendar days for spanning events, business days for project timelines, and Julian days for scientific precision. The tool you choose shapes the result, so know what the calculator counts – and what it leaves out.

Frequently asked questions