Calculate a Contract End Date from a Start Date in Excel
Question details
Calculate a contract end date from an NTP start date and a duration in days, leaving the result blank until both inputs are present.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A project or contract worksheet contains an NTP start date and a contract period in separate cells.
- Observed behavior
- The end date should update automatically when both inputs are entered and remain blank if either is missing.
Enter a valid Excel date in A2 and a numeric number of days in B2. Decide whether the start date counts as day one and whether the duration uses calendar days or working days.
Calculate the End Date Using Calendar Days
Use an IF formula to add the contract duration to the NTP date while keeping the result blank until both inputs are filled.
In Excel, enter the NTP start date in A2 and the contract duration in days in B2.
Select C2 and enter =IF(OR(A2="",B2=""),"",A2+B2). If the start date counts as day one, use =IF(OR(A2="",B2=""),"",A2+B2-1) instead.
Select column C, then choose Home > Number Format > Short Date or another date format.
Drag the fill handle at the bottom-right corner of C2 down through the rows that need an end date.

Calculate the End Date Using Working Days
Use WORKDAY when the duration excludes weekends and, optionally, listed holidays.
Calculate Contract End Dates in WPS Spreadsheets
Use WPS Spreadsheets to calculate end dates from start dates and durations, then fill the formula down your contract list.
- 1. Open your worksheet: Open WPS Spreadsheets and select Open to load your contract workbook.
- 2. Enter the contract details: Enter the NTP start date in A2 and the duration in days in B2.
- 3. Calculate the end date: Select C2 and enter =IF(OR(A2="",B2=""),"",A2+B2). Subtract 1 after B2 if the start date counts as day one.
- 4. Format and copy the formula: Select C2, choose a date format from the Home tab's number format controls, and drag the fill handle down to other rows.

Frequently Asked Questions
How do I count the start date as the first day?
For a positive duration, enter =IF(OR(A2="",B2=""),"",A2+B2-1) in C2. The subtraction makes the start date day one.
Why does the end date appear as a number?
Excel stores dates as serial numbers. Select the result cell and choose Home > Number Format > Short Date to display it as a date.
How can I exclude weekends and holidays?
Use =IF(OR(A2="",B2=""),"",WORKDAY(A2,B2,$D$2:$D$10)) in C2, with holiday dates listed in D2:D10. WORKDAY counts working days after the start date and excludes weekends and the listed holidays.
Will the formula treat a zero-day duration as blank?
No. If B2 contains 0, the formula treats it as a value. With the standard A2+B2 formula, the result is the start date.




