For a basic due date calculator in Excel, enter a start date in A2 and the number of calendar days in B2; in C2, use =A2+B2. Excel adds the days and displays the resulting date, which you can format as a date if it appears as a number.
How Excel Calculates Due Dates
Excel stores dates as sequential numbers, so adding a whole number to a date moves forward by that many calendar days. This makes a simple formula useful for tracking project deadlines, payment terms, renewal reminders, and other date-based tasks. The date in the result cell updates automatically if you change the start date or the number of days.
For example, assume A2 contains January 10, 2026, and B2 contains 30. With the formula above in C2, the result is February 9, 2026. The calculation treats January 11 as day one: the start date itself is not counted as one of the 30 days. That convention is common when someone says a deadline is “30 days after” a date, but an agreement or policy may define the count differently.
If the start date should count as day one, add one fewer day. With the same dates and values in A2 and B2, use =A2+B2-1 in C2; the result is February 8, 2026. Check the governing instructions before choosing between these interpretations. Excel can calculate the dates, but it cannot decide how a contract, workplace policy, or other rule counts days.
Set Up a Simple Due Date Calculator
A small table makes the calculation easy to reuse for many items. In a blank worksheet, add headings such as Start Date, Days to Add, and Due Date in cells A1, B1, and C1. Enter each start date in column A and the number of days in column B. In C2, use =A2+B2, then copy the formula down the column for the other rows.
To copy the formula, select C2 and drag the small square at the lower-right corner of the selection down through the rows you need. Excel adjusts the row references automatically: the next row will refer to A3 and B3, for example. If the list is likely to grow, select the data and choose Insert > Table. A formula entered in a table column usually fills down to the other rows and continues to apply to new rows.
- Use actual Excel dates in the start-date column, rather than words such as “next Monday.”
- Enter the day count as a number, such as 14 or 30, not as text.
- Keep the input columns separate from the calculated due-date column so the calculation is easy to check.
In Excel for Microsoft 365 on Windows, you can set the display through Home > Number Format > Short Date. Excel for Mac and Excel for the web also provide date formats from the Home tab, though ribbon layout can vary slightly. Formatting changes how a date looks, not the underlying calculation.
Calendar Days Versus Working Days
A basic addition formula counts every day, including Saturdays, Sundays, and holidays. For a task deadline measured in working days, use Excel’s WORKDAY function instead. With the start date in A2 and the number of workdays to add in B2, enter =WORKDAY(A2,B2) in C2. It skips Saturday and Sunday by default.
For example, if A2 is Friday, January 9, 2026, and B2 is 1, the result is Monday, January 12, 2026. The starting date is not counted as the first workday. This distinction matters: adding one calendar day would produce Saturday, January 10, while adding one workday produces Monday.
To skip company or public holidays as well, list holiday dates in F2:F10. With the same start-date and workday inputs in A2 and B2, use =WORKDAY(A2,B2,$F$2:$F$10) in C2. The dollar signs keep the holiday range fixed if you copy the formula down. Enter the holidays as real Excel dates, and include only dates that should be treated as nonworking days for your situation.
WORKDAY assumes a standard Saturday–Sunday weekend. If your organization uses a different weekly schedule, Excel also has WORKDAY.INTL, which lets you specify weekend days. Confirm the function’s weekend-code options in Excel’s function help before using it, and test the result against a date whose expected outcome you know.
Adding Months Instead of Days
“One month later” is not always the same as adding 30 days. Months have different lengths, and a due date tied to a monthly schedule may need to stay on the same day of the month where possible. Excel’s EDATE function adds a chosen number of months.
With a start date in A2 and the number of months to add in B2, enter =EDATE(A2,B2) in C2. If A2 is January 31, 2026, and B2 is 1, the result is February 28, 2026, because February has no 31st day. In a leap year, EDATE can return February 29 where appropriate. This is often more suitable than adding 30 days for monthly reminders or billing cycles, but the applicable terms determine which method to use.
EDATE can also calculate dates in the past: a negative number in B2 subtracts months. For a schedule with several monthly dates, enter the first date and calculate the next one from the preceding due date. Be aware that a date at the end of a month may shift to that month’s last valid day; decide whether that behavior matches the schedule you need.
Pregnancy Due Dates in Excel
Excel can also calculate an estimated pregnancy due date from the first day of the last menstrual period (LMP). A commonly used estimate is 280 days, or 40 weeks, after that date. With the LMP entered as a genuine date in A2, put =A2+280 in B2. For an LMP of May 1, 2026, the calculated date is February 5, 2027.
This is a calendar estimate, not a prediction of the exact day a baby will be born. The 280-day convention is based on pregnancy dating from the first day of the last menstrual period and assumes a typical 28-day cycle. Actual cycle timing varies, and a healthcare professional may revise an estimated date using clinical information, including ultrasound findings. Use a clinician’s guidance for personal care decisions; a spreadsheet is only a calculator.
Make sure the input is the first day of the last menstrual period, not the date of conception or the date a period ended. Those are different reference points. If you have been given a due date by a healthcare professional, use that date rather than treating this formula as a substitute.
Make Deadlines Easier to Read
Once the calculator works, a few presentation choices can help prevent mistakes. Format the result column as a date, widen columns so values are fully visible, and label whether the day count means calendar days or working days. If the sheet has different kinds of deadlines, add a separate column for the rule used, such as “calendar” or “business.” This helps another person understand why a date was calculated a particular way.
You can also highlight overdue dates with conditional formatting. If due dates are in C2:C100, select that range and choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Use =AND(ISNUMBER($C2),$C2<TODAY()) as the rule formula, then choose a formatting style. The ISNUMBER check prevents empty cells from being treated as overdue. TODAY updates with the current date when Excel recalculates, so a deadline can change from upcoming to overdue without editing the formula.
Common Errors and How to Fix Them
If a result appears as a number such as 46000 rather than a familiar date, the calculation may be correct: Excel is showing the underlying date serial. Apply a date format to the result cell. If the result shows an error or an unexpected date, check whether the start date is stored as text. A date that looks correct on screen may still be text if it was imported or entered in a format Excel did not recognize.
- Unexpected month or day: Date entry can be interpreted differently under different regional settings. Use a date format that is unambiguous in your setup, or select the cell and check its displayed date.
- Formula does not update down the table: Confirm that relative references such as A2 and B2 shift to the intended rows. Keep holiday ranges fixed with dollar signs.
- Weekend date appears: The basic addition formula counts weekends. Use WORKDAY when the deadline is measured in working days.
- Monthly result is not 30 days later: Use EDATE for month-based intervals; use ordinary addition when the requirement is a specific number of days.
- Due date is off by one: Check whether the starting day should count as day one. For a count that includes it, subtract one from the number added.
When a workbook is shared, agree on the date convention and the list of holidays before relying on the results. Excel calculates the rule entered in the cell; it does not know whether a local holiday, weekend, or contract-specific counting rule should change a deadline.
Frequently Asked Questions
How do I add 30 days to a date in Excel?
With the date in A2, enter =A2+30 in another cell. Format the result as a date if Excel displays a serial number.
How do I calculate a due date that skips weekends?
With the start date in A2 and workdays to add in B2, use =WORKDAY(A2,B2). Add a holiday range as the third argument if those dates should also be skipped.
Does Excel count the start date as day one?
No. Adding 30 to a date returns the date 30 days afterward, so the start date is excluded from the count. If your rule includes the start date as day one, add one fewer day.
How can I calculate a due date one month later?
With a start date in A2 and 1 in B2, use =EDATE(A2,B2). This handles months with different lengths, so the result may be the last day of a shorter month.
Can Excel calculate a pregnancy due date?
Yes. Adding 280 days to the first day of the last menstrual period gives a common estimated date. It is not a medical determination, so follow the date and advice provided by a healthcare professional.
Related
- Customizable Calendar Template in Excel: How to Make One
- Ctrl+H in Excel: Find and Replace Step-by-Step Guide
- Ctrl+Q in Excel: What Quick Analysis Does and How to Use It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel EDATE With Days Instead of Months: What to UseNo. EDATE adds months, not days; if A2 contains 10-Feb-2024 and B2 contains 30, use =A2+B2 to get…
- DATEDIF Formula Examples for Excel: Years, Months & DaysIn Excel, DATEDIF calculates the time between two dates in completed years, months, or days. For example, if…
- Snowflake Split by Delimiter: Functions and ExamplesTo split a string at a delimiter in Snowflake, use SPLIT(string, delimiter); it returns an array of the…
- Find Common Names in Excel with Formulas and FormattingTo find names that appear in two Excel lists, use COUNTIF to check whether each name in the…
- SUMIF With Multiple Criteria: Examples and AlternativesFor multiple criteria in Excel, use SUMIFS rather than SUMIF. With dates in A2:A8, regions in B2:B8, products…
- Excel Formula to Add Dates in SequenceTo add dates in sequence in Excel, enter a starting date in A2, then enter =A2+1 in A3…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.