How to Calculate End Date from Start Date and Duration in Excel?

Excel is a powerful data visualization and analysis software, which uses spreadsheets for managing, storing, and visualizing a large amount of data. A cell, a rectangular block is used to store each unit of data. This tool can be used to visualize trends or compare data by creating graphs, or get insights from the data using functions and formulas. It is primarily used for accounting purposes but can be used by anyone for many different tasks as per the requirements. Let’s see how to calculate the end date from the start date and duration.

Calculate the end date from the start date and duration (weeks)

 To calculate the end date from the start date and the number of weeks(duration), use the below formula:

=IF(start_date, start_date+(duration_in_weeks*7),””)

This formula will add (week * 7) days to the start date, as a week has 7 days. For purpose of demonstration use the below data to calculate the end date:

Step 1: Apply the formula,

Step 2: Drag the fill handle over to the data range.

Step 3: To change the value into date format, click the Home tab, and choose Short Date from the General drop-down list.

Output

Calculate the end date from the start date and duration (months)

To calculate the end date from the start date and a number of weeks (duration), use the below formula,

=DATE(YEAR(A2),MONTH(A2)+B2,DAY(A2))

This formula will add the duration into months to give the end date. For purpose of demonstration use the below data to calculate the end date:

Step 1: Apply the formula,

Step 2: Drag the fill handle over to the data range,

Calculate the end date from the start date and duration (years, months, and days)

To calculate the end date from the start date and the number of weeks, days, and years (duration), use the below formula,

=DATE(YEAR(A2)+B2,MONTH(A2)+C2,DAY(A2)+D2)

For purpose of demonstration use the below data to calculate the end date,

Step 1: Apply the formula,

Step 2: Drag the fill handle over to the data range,