TodayFree forever - no sign-up, no paid plans

How to add days to a date

By Daniel Mercer · Updated October 31, 2026

Open the Date Calculator

Adding days to a date sounds like the simplest job in the world, and it is - right up until the count crosses a month end, a February, or the New Year. This guide shows the reliable by-hand method, works through examples that cross each of those traps, and finishes with the spreadsheet and calculator shortcuts for when the span is too long to count on your fingers.

The one rule that makes every count come out right

Every correct day count rests on a single rule: the start date is day zero. When you add days to a date, you are counting the midnights you cross, not the days you touch. Add 1 day to a Friday and you land on Saturday. Add 7 days and you land on the Friday of the following week, because seven midnights have passed.

This is the method that deadlines, notice periods, ages and interest calculations all use, and it is the method our date calculator uses. If a contract or a manager counts the start day itself, their answer will be one day earlier than yours - neither of you has done the arithmetic wrong, you have just used different rules. Settle the rule first and the argument disappears. If you ever need the gap between two dates instead of a count forward, the days between calculator on our homepage does that job.

Worked example 1 - a count that stays inside one month

Start with the easy case. What date is 21 days after Friday, April 3, 2026?

April has 30 days, so there are 30 - 3 = 27 days left in April after the 3rd. Your count of 21 fits inside those 27, so the answer stays in April: 3 + 21 = 24. The date is Friday, April 24, 2026. Notice the weekday: 21 days is exactly 3 weeks, so the answer falls on the same weekday as the start. Any multiple of 7 keeps the weekday, which is a quick sanity check on every count you ever do.

Worked example 2 - crossing a month end

Now a count that leaves the start month behind. What date is 45 days after March 15, 2026?

Work through the months in order, spending the count as you go:

StepDays usedDays left to countYou are now at
Rest of March (31 - 15)1645 - 16 = 29March 31, 2026
Count 29 days into April290April 29, 2026

The answer is Wednesday, April 29, 2026. The pattern never changes: use up the rest of the current month, then whole months if the count is long, then the final partial month. The only facts you need are the month lengths - 31, 28 or 29, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 - and whether February has a 29th day in the year you are crossing.

How to add days to a date - a carved Halloween pumpkin marking the target date

Worked example 3 - crossing the New Year

Year boundaries frighten people more than they should. The method is identical; December simply hands over to January. What date is 45 days after November 22, 2026?

November has 30 days, so 30 - 22 = 8 days remain in November. December contributes 31, bringing the running total to 39. That leaves 45 - 39 = 6 days to count into January. The answer is Wednesday, January 6, 2027. When a count crosses February in a leap year, add the extra day to February's length and carry on - the method absorbs leap days without any special step.

Quick reference - common spans from today

Plenty of day-adding questions start from today, so here are the spans people ask for most, worked from Sunday, November 22, 2026. Each row keeps the weekday check visible: spans that are whole weeks keep Sunday, the others shift.

AddResulting dateWeekday
7 daysNovember 29, 2026Sunday
14 daysDecember 6, 2026Sunday
30 daysDecember 22, 2026Tuesday
60 daysJanuary 21, 2027Thursday
90 daysFebruary 20, 2027Saturday

For any other start date, the date calculator does the same work instantly and shows the weekday of the result, which is the part people most often need for planning meetings, deliveries and start dates.

The three mistakes that shift the answer

Counting the start day. If you point at the start date and call it "one", every answer comes out one day early. This is the single most common date mistake in offices, and it is why two careful people can disagree by exactly one day.

Assuming every month has 30 days. Seven months have 31 days, and a count that crosses two of them gains two days over the rough estimate. The 30-day shortcut is fine for a guess and wrong for a deadline.

Forgetting February 29. Any count that crosses the end of February in a leap year - 2024, 2028, 2032 - needs the extra day. Counts that cross February in other years do not. If your span includes a February, check the year before you trust the answer.

The shortcut versions

In Excel or Google Sheets, dates are stored as day numbers, so adding days is plain arithmetic: =A1+45 adds 45 days to the date in cell A1. If the result shows as a long number, the cell is formatted as a number - reformat it as a date. And for counts longer than a few weeks, or counts you will repeat, a calculator beats fingers every time: enter the start date, choose Add, type the number of days, and read off the date and its weekday.

Frequently asked questions

Does the start date count when I add days to a date?

No, not in the standard method. The start date is day zero, so adding 1 day to a Friday gives Saturday. This is the method deadlines, notice periods and interest calculations use. If your situation counts the start day itself, add one extra day to your number before you start.

How do I add days to a date in Excel?

Put the start date in a cell, for example A1, and use the formula =A1+21 to add 21 days. Excel stores dates as day numbers, so plain addition works. Format the result cell as a date if it shows a number like 46137 instead.

What is 30 days after October 31?

November 30. October 31 plus 30 days crosses the whole of November, which has exactly 30 days, so the count lands on the last day of November. Adding days is not the same as adding a month, even when the answers happen to sit close together.

Why does my answer differ from a calculator by one day?

Almost always because one of you counted the start day and the other did not. The standard method counts the midnights you cross, so the start day is never included. Check which method the other tool or person used before assuming the arithmetic is wrong.

Can I add business days instead of calendar days?

Yes, but that is a different count. Business days skip weekends and usually holidays, so 10 business days is normally 14 calendar days or more. Use the business days calculator for that job, or the WORKDAY function in a spreadsheet.

Related guides

How to subtract days from a date

Counting backward from a date, with the same midnight rule in reverse.

How to add weeks to a date

The multiply-by-7 shortcut that keeps the weekday unchanged.

How to add days in Excel - simple formulas and EDATE

Plain addition for days, EDATE for months, and the formatting fix.

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

Two methods, two different answers - and when each one is right.

Daniel Mercer

Daniel Mercer builds and maintains the calculators on this site. He spent ten years in payroll and operations roles counting business days, notice periods and deadlines by hand, and writes these guides the way he would explain the count to a colleague - the rule first, a worked example second, and the common mistake called out before it happens.