For a due date a set number of calendar days after a start date, put the start date in A2 and the number of days in B2, then enter =A2+B2 in the due-date cell. For working days, use =WORKDAY(A2,B2) instead; the right formula depends on whether weekends and holidays count.
How Excel date calculations work
Excel stores dates as serial numbers, so adding a number to a genuine date advances that date by the same number of days. The cell may display a date such as 12-Mar-2026, but Excel can use its underlying number in calculations. This is why ordinary addition is enough for many due-date calculations.
A cell that looks like a date may actually contain text—for example, a date imported from a system or entered in a format Excel does not recognize. Text dates may not calculate as expected. Enter dates in a format recognized by your regional settings, or construct them with Excel’s DATE function. For instance, with year, month, and day stored in separate cells, you can make a real date from those parts rather than joining them as text.
Also decide what the due-date rule means before choosing a formula. A payment due 30 days after an invoice date normally uses 30 elapsed calendar days. A task due after five working days usually excludes weekends, and possibly listed holidays. Some rules count the start date as day one; others start counting the following day. That one-day distinction can change the result.
Calculate a due date in calendar days
With the start date in A2 and the number of calendar days to add in B2, enter =A2+B2 in C2. If A2 contains 10-Feb-2026 and B2 contains 30, C2 returns 12-Mar-2026. The start date is day zero in this calculation: Excel moves forward 30 days from it.
If the start date is counted as the first day of the period, subtract one from the interval. With the same layout, where A2 is the start date and B2 is the total number of days including that start date, use =A2+B2-1. For example, a 10-day period beginning on 10-Feb-2026 ends on 19-Feb-2026 under this convention. Confirm which counting rule applies to the agreement or process you are tracking.
To calculate a date a fixed number of days after a date without relying on how a typed date is interpreted, you can use DATE. With the start date built from year, month, and day values directly in the formula and 30 calendar days to add, enter =DATE(2026,2,10)+30. The result is 12-Mar-2026. DATE is also useful when a spreadsheet stores year, month, and day in separate columns.
Choose calendar days or working days
Use calendar-day addition when every day counts, including Saturdays, Sundays, and holidays. It is appropriate for rules stated in calendar days, but it does not automatically move a result that falls on a weekend to the next weekday. If a contract or internal policy says a deadline rolls forward when it lands on a nonworking day, that adjustment needs to be handled separately.
Use WORKDAY when the interval is measured in working days and Saturday and Sunday are the standard weekend. With the start date in A2 and the number of working days to add in B2, enter =WORKDAY(A2,B2). If A2 is Tuesday, 10-Mar-2026, and B2 is 5, the result is Tuesday, 17-Mar-2026: Wednesday through Friday count as the first three days, then Monday and Tuesday make five.
WORKDAY treats the start date as the starting point, not as the first working day in the count. If the start date itself should count as day one, adjust the interval or define the rule carefully; do not assume that adding five working days means the same thing as counting the start date among five days. Similarly, a zero interval returns the start date, subject to the function’s date handling.
Add calendar months or find month-end dates
For a deadline measured in months, use EDATE rather than adding a fixed number of days. A month is not always 30 days, so a fixed-day shortcut can produce the wrong date. With the start date in A2 and the number of months to add in B2, enter =EDATE(A2,B2). If A2 is 31-Jan-2025 and B2 is 1, the result is 28-Feb-2025. EDATE keeps the intended month interval and returns the last valid day when the target month has no matching day number.
To get the last day of a month, use EOMONTH. With a date in A2 and the number of months to move in B2, enter =EOMONTH(A2,B2). If A2 is 15-Apr-2026 and B2 is 0, the result is 30-Apr-2026; if B2 is 1, it returns 31-May-2026. This can help when a process is due at month-end rather than on the same numbered day in a later month.
EDATE and EOMONTH return date values, but the result may display as a serial number if the output cell is formatted as General or Number. Apply a date format to see a readable date. These functions are designed for calendar-month rules; they do not account for working days or holidays.
Exclude holidays and customize weekends
WORKDAY can skip holidays listed in a range. With the start date in A2, working-day interval in B2, and holiday dates in F2:F10, enter =WORKDAY(A2,B2,$F$2:$F$10). Each holiday cell must contain a real Excel date. Blank cells in the referenced range are ignored, so the range can include unused rows for future holidays.
If the weekend is not Saturday and Sunday, use WORKDAY.INTL. With the same start date and interval in A2 and B2, and holiday dates in F2:F10, enter =WORKDAY.INTL(A2,B2,1,$F$2:$F$10). The weekend argument 1 means Saturday and Sunday. WORKDAY.INTL also allows other weekend patterns; check the function’s weekend-code options before using a code, especially for a one-day weekend or a weekend spanning different days.
Keep the holiday list specific to the relevant calendar. A public holiday in one country, region, or company may be an ordinary workday in another. Likewise, a spreadsheet formula cannot determine whether a particular organization closes for an additional day unless that date is included in the holiday range. For recurring schedules, maintain the list for the full date range your formulas may cover.
Enter and display dates reliably
For a small sheet, type a date into a cell and confirm Excel recognizes it as a date. For formulas or reusable templates, DATE is a dependable way to build one from numeric year, month, and day values. Avoid relying on ambiguous entries such as 04/05/2026: depending on regional settings, that can mean April 5 or May 4.
To format a result, select the date cells and choose Home > Number group > Short Date. For more control, open Format Cells with Ctrl+1 on Windows or Command+1 on Mac, then select a date format. The exact display may differ by locale, but changing the format does not change the underlying date calculation.
For a column of due dates, enter the formula in the first row and fill it down using the fill handle or copy and paste. Relative references such as A2 and B2 adjust to A3 and B3 in the next row. A holiday range should generally remain fixed when copied, which is why the example uses dollar signs around F2:F10. If the formula is copied sideways or down, that absolute reference continues pointing to the same holiday list.
Common due-date formula problems
- The result is a number. The calculation may be correct, but the result cell is formatted as General or Number. Apply a date format.
- The formula returns an error or does not update. Check that the start date is a real date, the day or month interval is numeric, and the formula begins with an equals sign. Also check that calculation is not set to Manual if the workbook is not recalculating.
- The result is one day too late or early. Review whether the start date counts as day one. A2+B2 excludes the starting date from the number of days added; A2+B2-1 counts it within the period.
- A weekend appears as the due date. Ordinary addition does not skip weekends. Use WORKDAY for working-day intervals, or apply the separate weekend-roll rule required by the process.
- A holiday was not skipped. Confirm the holiday is in the referenced range and stored as a date, not text. Check that the range includes every relevant holiday.
- A month-based deadline looks unexpected. EDATE adjusts to the last valid day when the target month is shorter. A date on the 31st plus one month does not create a nonexistent 31st in February.
How to choose the right formula
Match the formula to the unit and rule, not just to the number of days someone mentions. Use this quick guide:
- Calendar days after a start date: add the interval with A2+B2.
- Calendar days where the start date is counted as day one: use A2+B2-1.
- Working days with a Saturday-Sunday weekend: use WORKDAY.
- Working days with a holiday list: use WORKDAY with the holiday range.
- Working days with a different weekend pattern: use WORKDAY.INTL.
- A number of calendar months later: use EDATE.
- The last day of a month: use EOMONTH.
Before filling formulas down a large tracker, test a few edge cases: a start date immediately before a weekend, a date near the end of a month, a leap-year February, and a listed holiday. That small check can expose a wrong counting convention or an incomplete holiday list before it affects many rows.
Frequently Asked Questions
What is the simplest Excel formula to add 30 days to a date?
With the start date in A2, enter =A2+30. This adds 30 calendar days, including weekends and holidays.
How do I calculate a due date that skips weekends?
With the start date in A2 and the number of working days in B2, use =WORKDAY(A2,B2). It skips Saturday and Sunday but does not know about holidays unless you provide a holiday range.
How do I include holidays in an Excel due-date calculation?
Put the holiday dates in a range such as F2:F10. With the start date in A2 and the working-day interval in B2, use =WORKDAY(A2,B2,$F$2:$F$10).
Can Excel calculate a due date one month from today?
Yes. With the date to start from in A2 and one month to add, use =EDATE(A2,1). If you specifically need the last day of the following month, use EOMONTH instead.
Why does my due date formula show a serial number?
Excel stores dates as numbers. Select the result cell and apply a date format from Home > Number group > Short Date; the formula itself usually does not need to change.
Related
- Excel Conditional Formatting Icons: How to Use Them
- Excel Conditional Formatting Icon Sets: A Practical Guide
- Excel 3-Flag Icon Set: Setup and Thresholds
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Transpose Bottom to Top: Formulas and Fixes GuideTo transpose a vertical list from bottom to top into a horizontal row in Excel for Microsoft 365,…
- Excel Filter in Table Format: How to Set Up and Use ItTo filter data in an Excel table, click a cell in the table and use the drop-down arrow…
- How to Apply a Filter in Excel to Find Data FastTo apply a filter in Excel, click a cell in your data, then choose Data > Filter. Use…
- Excel Formula Bot Free? Free Plans, Limits, and Safe UseYes—many Excel formula bots offer free access, but it is usually limited by usage, features, or account requirements.…
- Concatenate First Letter and Last Name in ExcelIf first names are in A2 and last names are in B2, enter =LEFT(TRIM(A2),1)&" "&TRIM(B2) to combine the…
- Excel XLOOKUP and Power Query: How They Work TogetherExcel XLOOKUP and Power Query work together, but they do different jobs: Power Query imports, cleans, and combines…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.