Function Problems

Calculate a Contract End Date from a Start Date in Excel

Muhammad TalhaMuhammad Talha Nov 18, 2026 869 views

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.

Calculate a Contract End Date from a Start Date in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the inputs

In Excel, enter the NTP start date in A2 and the contract duration in days in B2.

2
Add the formula

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.

3
Format the result

Select column C, then choose Home > Number Format > Short Date or another date format.

4
Apply it to other rows

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 Calendar Days
Check how the duration is counted: The first formula adds elapsed calendar days. Use the minus-one version for a positive duration when the start date is day one.
Calculate dates in WPS Spreadsheets

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. 1. Open your worksheet: Open WPS Spreadsheets and select Open to load your contract workbook.
  2. 2. Enter the contract details: Enter the NTP start date in A2 and the duration in days in B2.
  3. 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. 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.
Calculate contract end dates with IF and date arithmeticOpen and save Microsoft Excel XLSX filesKeep end-date cells blank until both inputs are presentUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.