Adding Days and Months to a Date: Deadlines, Month-End Rules, and Business Days

Adding Days

Days are straightforward because they are a fixed unit. From October 21, 2026: add 30 days to reach November 20, 2026; add 90 days to reach January 19, 2027; add 180 days to reach April 19, 2027. To add days manually, count the days left in the current month, then roll into the next month, subtracting each month's length.

A 30-day trial that starts October 21 ends on November 20 if the start date counts as day 0, or on November 19 if the first day counts as day 1. Always check how the contract counts.

Adding Months and the Month-End Problem

Adding one month to October 21 gives November 21. The trouble starts at the end of the month. One month from January 31 does not exist as a date in February. Systems resolve this in different ways: some give February 28 (or 29 in a leap year), the last day of the month; others roll into March, giving March 3 by adding the leftover days.

The common rule in finance and contracts is the 'end-of-month' or 'following' convention: if the day does not exist in the target month, use the last day of that month. Spreadsheet functions such as EDATE follow this: EDATE(Jan 31, 1) returns Feb 28. Check what your software or contract specifies.

Weekends and Holidays

If the computed date falls on a Saturday, Sunday, or public holiday, many agreements move the deadline to the next business day. This is the 'following business day' convention. Others use 'preceding business day', which moves it earlier, and some, like certain statutory deadlines, extend only if the last day is a court holiday. Always read the wording.

Business-day addition skips weekends and holidays: 10 business days from Wednesday, October 21 ends on Wednesday, November 4, if there are no holidays in between.

Common Situations

A 30-day return window, a 14-day cooling-off period, a 90-day probation, a net-30 invoice, a 12-month warranty. For net-30 invoices dated October 21, payment is due November 20. For a 12-month warranty purchased on February 29, the end date becomes February 28 or March 1 in non-leap years, depending on the terms. For quarterly dates, adding 3 months to November 30 gives February 28 (or 29).

In legal contexts, courts may interpret a month as a calendar month, not 30 days. A one-month period from a start on the 15th generally ends on the 15th of the next month.

Practical Tips

Write the start date and the end date explicitly in contracts rather than just the length of time. Put a reminder a few days before. When two parties are in different time zones, specify the time zone for deadlines that fall at midnight. If a date matters, confirm by counting days on a calendar or with a reliable date calculator.