TodayFree forever - no sign-up, no paid plans

Date Counting Guides

120 practical guides on counting days, business days, weeks and months between dates - every one with worked examples and the common mistakes called out. Use the search box or jump to a topic.

Days Between guides Business days guides Date calculator guides Days until guides Weeks guides Months guides

Days Between guides

How to calculate days between two dates by hand

Learn how to calculate days between two dates by hand with the midnight method and day-of-year method, plus worked examples.

How to count business days between two dates

How to count business days between two dates: skip weekends, remove holidays, and avoid the mistakes that move deadlines.

Include the end date or not - inclusive vs exclusive counting

Include the end date or not? Inclusive vs exclusive counting explained with examples for hotels, leave, deadlines and contracts.

How to calculate days between dates in Excel (NETWORKDAYS and DATEDIF)

Calculate days between dates in Excel with subtraction, DATEDIF and NETWORKDAYS. Formulas, examples and fixes for common errors.

How to calculate days between dates in Google Sheets

Calculate days between dates in Google Sheets with DAYS, DATEDIF and NETWORKDAYS, with step-by-step examples that just work.

How many days are in each month - and how to remember them

How many days are in each month? The full table, the knuckle method and the rhyme, plus why February breaks the pattern.

Leap years and what they do to a day count

Leap years add February 29, and that one day changes some counts but not others. Here is when a leap year matters and when it does not.

How to calculate how many days until a date

How to calculate how many days until a date: the by-hand method, the spreadsheet method, and the mistakes that throw counts off.

How to calculate days since a date - like the day you were born

Calculate days since a date, from your birthday to an anniversary, with the same-day rule explained and worked examples.

How to calculate weeks between two dates - the quick method

The quick way to calculate weeks between two dates: count the days, divide by seven, and read full weeks and leftover days correctly.

How to calculate months and years between two dates

How to calculate months and years between two dates with the anniversary method, including the month-end cases that trip people up.

How lawyers count days for court deadlines

How lawyers count days for court deadlines: exclude the trigger day, count every day, and extend past weekends and holidays.

How to count days in a notice period or contract

How to count days in a notice period or contract: when the clock starts, clear days, and the wording that changes the answer.

How to count days for leave, holidays and hotel stays

How to count days for leave, holidays and hotel stays - three systems that look alike but charge your days very differently.

How to count the days between paychecks

Count the days between paychecks for weekly, biweekly, semi-monthly and monthly pay, and spot the long gaps before they bite.

How to calculate the date 90 days from any date

How to calculate the date 90 days from any date by hand, in a spreadsheet, or with a preset, with month-by-month worked examples.

How HR counts days in a probation period

How HR counts days in a probation period: calendar days vs business days, the start-date question, and extensions explained.

Counting days for project planning and delivery dates

Counting days for project planning and delivery dates: elapsed days, working days, buffers, and how to promise a date you can hit.

How to calculate your age in days

Calculate your age in days and find your next 1,000-day milestone, with the leap day counting done for you step by step.

Off-by-one errors - the most common days between mistake

Off-by-one errors are the most common days between mistake. Learn why counts come out one day short or long, and how to fix them.

Business days guides

How to Count Business Days for a Deadline

Count business days for a deadline the right way: skip weekends and holidays, and never count the start day. The method, with worked examples.

Business Days vs Working Days vs Weekdays

Business days vs working days vs weekdays: the three terms sound alike but count differently. What each one means, and when it costs you a day.

How to Calculate Business Days in Excel with NETWORKDAYS

Calculate business days in Excel with NETWORKDAYS: the formula, a holiday list, worked examples, and the inclusive-counting trap to avoid.

NETWORKDAYS.INTL - How to Count Business Days with a Custom Weekend

NETWORKDAYS.INTL counts business days with a custom weekend: Friday-Saturday, one day off, or any pattern. Weekend codes, strings and examples.

How to Exclude Holidays from a Business Day Count

Weekends are only half the job. Learn how to exclude holidays from a business day count by hand, in Excel, and with a calculator.

US Federal Holidays - Which Days Are Not Business Days

The 11 US federal holidays are not business days for banks, courts and federal offices. Full 2026 and 2027 lists with observed dates explained.

Observed Holidays - What Happens When a Holiday Falls on a Weekend

When a federal holiday falls on a Saturday or Sunday, the day off moves to Friday or Monday. How observed holidays work, with 2026-2028 shifts.

How to Add Business Days to a Date for Delivery Dates and Deadlines

Add business days to a date to set delivery dates and deadlines: the forward-count method, worked examples with holidays, and the WORKDAY shortcut.

How Banks and Lenders Count Business Days

Banks count business days by the Federal Reserve calendar, not yours. How banks and lenders count business days for wires, ACH, checks and loans.

How to Count Business Days for a Contract or SLA Deadline

A contract or SLA deadline in business days is only as clear as its definition. How to count business days for a contract, cure period or SLA safely.

10 Business Days - How Many Calendar Days Is That Really

10 business days is usually 14 calendar days, but your start day and holidays change it. The full conversion table for 1 to 30 business days.

5 Business Days From Today - What Date Will It Be

5 business days from today is usually one week away, but holiday weeks push it further. Today's worked answer, the method, and a start-day table.

Weekends Are Not Always Saturday and Sunday - Business Days Around the World

Saturday and Sunday is not the world's only weekend. How weekends around the world differ, and what that does to international business day counts.

How HR Counts Business Days for Leave and Notice Periods

HR counts business days for leave and notice periods by policy, not by guesswork. How the counts work, with resignation and Christmas leave examples.

Common Business Day Mistakes That Move a Deadline

One wrong assumption about weekends, holidays or start days can move a deadline by days. The common business day mistakes, with the correct count.

How to Count Business Days for Shipping and Delivery Estimates

Carriers promise transit in business days, not calendar days. How to count business days for shipping and delivery estimates that actually hold up.

Business Days vs Calendar Days in Real Estate Closings

Business days vs calendar days can move a real estate closing by a week. How disclosure, rescission and contract deadlines count each kind of day.

How to Calculate Business Days in Google Sheets

Calculate business days in Google Sheets with NETWORKDAYS, WORKDAY and a holiday list: formulas, worked examples, and a live days-remaining tracker.

Half Days and Partial Days - Do They Count as Business Days

Do half days and partial days count as business days? How payroll, leave policies, SLAs and early closings treat a day you only partly work.

Counting Business Days by Hand vs a Calculator - an Accuracy Check

Is counting business days by hand reliable? We counted a full quarter by hand and with a calculator - here is where the two methods disagreed.

Date calculator guides

How to add days to a date

How to add days to a date by hand, in a spreadsheet, or with a calculator - worked examples, the month-end trap, and the mistakes to avoid.

How to subtract days from a date

How to subtract days from a date and land on the right day - counting backward by hand, in Excel, and with a calculator, with examples.

What date is 90 days from today?

What date is 90 days from today? The answer for today, the method for any start date, and why 90 days is not the same as 3 months.

What date is 30, 60 and 180 days from today - a quick reference

A quick reference for what date is 30, 60 and 180 days from today, plus how to work out the same spans from any start date you choose.

How to calculate the date 45 days from now

How to calculate the date 45 days from now from any start date - the by-hand method, calendar shortcuts, and the off-by-one mistake to avoid.

How to find the date 100 days ago

How to find the date 100 days ago from today or any date - counting back by hand, the day-of-year shortcut, and checking your answer.

Adding months to a date - the month-end problem explained

Adding months to a date gets tricky at month end: January 31 plus one month lands on February 28. Here is the clamp rule and why it matters.

How to add weeks to a date

How to add weeks to a date: multiply by 7, keep the weekday, and check real examples - 6 weeks, 12 weeks and 26 weeks worked out in full.

How to calculate a due date 40 weeks from a date

How to calculate a due date 40 weeks from a date - the 280-day method, Naegele's rule, and why only a small share of babies arrive on the day.

How to work out a deadline date from a start date

How to work out a deadline date from a start date - calendar days vs business days, the start-day rule, and a worked example with holidays.

How to add days in Excel - simple formulas and EDATE

How to add days in Excel with a simple formula, and when to use EDATE for months instead - examples, formatting fixes, and common errors.

How to add business days in Excel with WORKDAY

How to add business days in Excel with WORKDAY and WORKDAY.INTL - skip weekends and holidays, with a worked example around Thanksgiving.

How to add days to a date in Google Sheets

How to add days to a date in Google Sheets with a simple formula, EDATE, and WORKDAY - plus the locale and formatting traps that break results.

Counting forward vs counting backward - common date mistakes

Counting forward vs counting backward trips people up in predictable ways. The common date mistakes, why they happen, and how to check both ways.

How to calculate the date 6 months from now

How to calculate the date 6 months from now from any start date - the same-date rule, the month-end clamp, and why 6 months is not 182 days.

How to find the date of a future appointment, renewal or expiry

How to find the date of a future appointment, renewal or expiry - work forward from the last one, set the reminder, and never miss a deadline.

What date is 1,000 days from today?

What date is 1,000 days from today? The answer, the long-way-round method for checking it, and fun ways people use a 1,000-day milestone.

How to calculate expiry dates and warranty end dates

How to calculate expiry dates and warranty end dates - the anniversary rule, day-count warranties, and the one-day traps in the fine print.

Adding years to a date - leap year edge cases

Adding years to a date is simple until February 29 gets involved. The leap year edge cases, the clamp rule, and how contracts handle them.

Why adding 30 days is not the same as adding one month

Why adding 30 days is not the same as adding one month - the three reasons the answers differ, and which one your document actually means.

Days until guides

How Many Days Until a Date - How the Count Works

How many days until a date? Learn how the count works - midnights, not 24-hour blocks - with worked examples and the off-by-one trap explained.

How Many Days Until Christmas - How the Count Works

How many days until Christmas? From November 22, 2026 the answer is 33. See how the count works and how to work it out for any date.

How to Count Down the Days to a Wedding

Counting down the days to a wedding? Turn one big number into milestones, monthly jobs and a final-week plan, with a worked example.

Days Until Retirement - How to Plan the Countdown

Days until retirement feel abstract until you plan them. Set the date, count the working days left, and turn the countdown into a checklist.

How Many Days Until Your Birthday?

How many days until your birthday? Work out the count, handle a birthday that already passed this year, and find your next day-milestone.

How to Count the Days Until an Exam or Test Day

Count the days until an exam, then turn them into a study plan: total days, weekdays only, and a worked 113-day example to test day.

Days Since vs Days Until - Reading a Countdown Both Ways

Days since vs days until: the same subtraction read in two directions. Learn when each count applies and how the sign flips on the day itself.

How to Make a Countdown You Can Share

Make a countdown you can share: a link that carries the date, a printable wall chart, or a simple message format anyone can check.

How Many Days Until the New Year?

How many days until the new year? From November 22, 2026 it is 40 days to January 1, 2027. Here is how the count works, week by week.

How to Count the Days Until a Vacation or Trip

Count the days until a vacation the useful way: total days, working days left to clear, and the deadlines hiding inside the countdown.

Milestone Days - 100, 50 and 30 Days to Go

Milestone days turn a long countdown into deadlines: find your 100, 50 and 30 days to go dates and give each one a job to finish.

How to Count Weekdays Only in a Countdown

Count weekdays only in a countdown when weekends do not move your deadline: the method, a worked example, and the holiday adjustment.

How Many Days Until Halloween and Thanksgiving

How many days until Halloween and Thanksgiving? The dates move differently - one fixed, one floating - so here is how each count works.

Days Until a Due Date - Counting Down in Days

Days until a due date: how the 40-week count works, why the due date is an estimate, and how to count the days you have actually completed.

How to Calculate Days Since an Event - Anniversaries and Streaks

Calculate days since an event - an anniversary, a streak, a last cigarette - with the midnight rule, worked examples and milestone dates.

Countdown Mistakes - Why Your Count Is Off by One Day

Countdown mistakes usually cost exactly one day. Find the five causes - counting today, time zones, leap years - and how to check your count.

How to Build a Live Countdown in Excel or Google Sheets

Build a live countdown in Excel or Google Sheets with TODAY and NETWORKDAYS formulas that update every morning - full formulas and fixes.

Days Until a Deadline - Planning Backwards from a Date

Days until a deadline are only useful backwards: split the count into phases, place buffers, and find your real start date. Worked example.

How Many Days Until Summer?

How many days until summer depends on which summer you mean: June 1, the solstice on June 21, or the school break. All three counts explained.

How to Count the Days Since You Were Born

Count the days since you were born with the day-of-year method, find your next 1,000-day milestone, and check the leap days inside your count.

Weeks guides

How to Calculate Weeks Between Two Dates

Learn how to calculate weeks between two dates: divide the day count by 7, read full weeks and leftover days, with worked examples.

Full Weeks vs Partial Weeks - How to Read the Answer

Full weeks vs partial weeks explained: what a calculator means by 10 weeks and 4 days, and which figure to use for deadlines, pay and leave.

How to Convert Days Into Weeks and Leftover Days

Convert days into weeks and leftover days with one division: 100 days is 14 weeks and 2 days. Includes a conversion table and common mistakes.

Decimal Weeks - When to Use Them and When Not To

Decimal weeks turn a day count into a single number like 10.57 weeks. See when decimal weeks help, when they mislead, and how to convert back.

How to Calculate Weeks Between Dates in Excel

Calculate weeks between dates in Excel with INT and MOD: full weeks, leftover days and decimal weeks, plus the errors that break the formula.

How to Calculate Weeks Between Dates in Google Sheets

Get weeks between dates in Google Sheets using INT, MOD and ISOWEEKNUM, with full weeks, leftover days and decimal weeks from two dates.

Workweeks vs Calendar Weeks - The Difference That Matters for Pay

Workweeks vs calendar weeks are not the same count. See how each one works, why payroll uses workweeks, and how the two answers differ.

How to Count Weeks for a Project Timeline

Count weeks for a project timeline the way planners do: set the start Monday, count full weeks, place milestones, and allow for holidays.

How Many Weeks Are in a Month - and Why the Answer Varies

How many weeks are in a month? Between 4 and 4.43 depending on the month. See the exact figure for each month length and the 4.345 average.

How Many Weeks Are in a Year - 52 Weeks and the Extra Days

How many weeks are in a year? 52 full weeks plus 1 extra day, or 2 in a leap year. ISO years sometimes have 53 weeks - here is the difference.

How to Count Weeks Between Two Dates for Pregnancy Tracking

Count weeks between two dates for pregnancy tracking: work out how far along you are from the last period date, and what 40 weeks really means.

ISO Week Numbers Explained - What Week of the Year Is It?

ISO week numbers explained: weeks start on Monday, week 1 holds the first Thursday, and some years have 53 weeks. Find any date's week number.

Week Counting Mistakes - Off-by-One Errors and Partial Weeks

Week counting mistakes usually cost exactly one day or one week. The off-by-one error, partial week traps and inclusive counting, explained.

How to Add Weeks to a Date

Add weeks to a date by multiplying by 7: 6 weeks after June 1, 2026 is July 13. Weekday stays the same - here is the method and the traps.

How Many Weeks Until a Date - Counting in Whole Weeks

How many weeks until a date? Count the days, divide by 7, and read whole weeks plus leftover days - the honest way to answer weeks to go.

How School Terms and Semesters Are Counted in Weeks

School terms and semesters are counted in weeks of five school days: about 36 weeks a year, 18 a semester. How districts and colleges count.

Weeks Between Paychecks - Biweekly Pay Explained

Weeks between paychecks on a biweekly schedule is always 2, giving 26 paydays a year - and sometimes 27. How the extra payday year happens.

How to Count Weeks for a Rental or Lease Period

Count weeks for a rental or lease period without overpaying: full weeks, part weeks, and why a month is not four weeks on a lease.

Converting Weeks to Months - The 4-Week Month Myth

Converting weeks to months with the 4-week shortcut overstates every span. Use the real average month of 4.345 weeks - here is the math.

How to Count Weeks by Hand on a Calendar

Count weeks by hand on a calendar by marking the same weekday: every seventh day is one more week. A pencil method that never needs a formula.

Months guides

How to calculate months between two dates

Learn how to calculate months between two dates by hand: count full months, handle leftover days, and check your answer free.

Full months vs partial months - how to read the answer

Full months vs partial months explained: what a counter is really telling you, with examples of complete months and leftover days.

How to calculate months between dates in Excel with DATEDIF

Calculate months between dates in Excel with DATEDIF: the M, MD and YM units, worked examples, and the errors to watch for.

DATEDIF units explained - Y, M, D, YM, MD and YD

DATEDIF units explained one by one - Y, M, D, YM, MD and YD - with a single worked example that shows what each unit returns.

How to calculate months between dates in Google Sheets

Get months between dates in Google Sheets with DATEDIF, plus a fallback formula for full months and leftover days.

Months only vs years and months - two ways to read the same span

Months only vs years and months: when to report 38 months and when to say 3 years 2 months, with examples for age, tenure and contracts.

The average month - why 30.44 days is used and when it misleads

The average month is 30.436875 days. Here is where that figure comes from, when it is safe to use, and when it quietly misleads.

How to count months for a baby's age

How to count months for a baby's age using the monthiversary rule, including February babies and babies born on the 31st.

How to count months on a lease or contract

How to count months on a lease or contract: start dates, end dates, and why a 12-month lease rarely ends on the anniversary day.

Month-end dates - why January 31 plus one month is tricky

Month-end dates explained: why January 31 plus one month lands on February 28, and how Excel, Sheets and payroll systems clamp.

How to calculate months of service or employment

Calculate months of service or employment the way HR does: full months, leftover days, and how tenure figures get rounded.

Age in months - how to count months between two birthdays

Age in months made simple: count full months between two birthdays, compare siblings fairly, and handle end-of-month birthdays.

Months between dates for loan and interest periods

Months between dates for loans and interest periods: how lenders count full months, leftover days and day-count conventions.

Common months-between mistakes - rounding and partial months

The most common months between mistakes: the 30-day month shortcut, rounding partial months up, and trusting an average month.

How to add months to a date

How to add months to a date by hand, in Excel with EDATE, and in Google Sheets - including the month-end clamping rule.

How to convert months into years and days

Convert months into years and days two ways: exact calendar counting and the average-month shortcut, with worked examples.

How to count months for a subscription or billing cycle

How to count months for a subscription or billing cycle: anchor days, clamped February renewals and annual plan math.

Fractional months - when a decimal answer is the honest one

Fractional months explained: when a decimal like 1.48 months is the honest answer for rent, billing and interest, and when it is not.

How HR counts months in a probation or notice period

How HR counts months in a probation or notice period: the two end-date conventions, worked examples, and what to check in your contract.

Months between dates by hand - the step-by-step method

Work out months between dates by hand with a four-step method, one long worked example, and a quick way to check your answer.