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:
| Step | Days used | Days left to count | You are now at |
|---|---|---|---|
| Rest of March (31 - 15) | 16 | 45 - 16 = 29 | March 31, 2026 |
| Count 29 days into April | 29 | 0 | April 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.

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.
| Add | Resulting date | Weekday |
|---|---|---|
| 7 days | November 29, 2026 | Sunday |
| 14 days | December 6, 2026 | Sunday |
| 30 days | December 22, 2026 | Tuesday |
| 60 days | January 21, 2027 | Thursday |
| 90 days | February 20, 2027 | Saturday |
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.
