How to Add 12 Weeks to a Date in Excel

Add 12 weeks -- or any number of weeks -- to dates in Excel by using a formula to add the corresponding number of days.

Step

Insert a new column designed to hold the new dates and select the cell where the first new date should appear. Click the fx icon to open the Function Arguments window.

Click the fx icon after selecting an empty cell.
credit: Image courtesy of Microsoft
Select Sum and click OK.
credit: Image courtesy of Microsoft

Step

Select Sum from the list of available functions and click the OK button.

Place your cursor in the Number1 field and click the first date.
credit: Image courtesy of Microsoft

Step

Place your cursor in the Number1 field and select the first date from the spreadsheet.

Enter the number of days you want to add to the date and click OK.
credit: Image courtesy of Microsoft

Step

Enter the number of days you want to add to the date in the Number2 field and click the OK button. For example, to add 12 weeks to a date, enter 84 (12 multiplied by 7).

Drag the fill handle down.
credit: Image courtesy of Microsoft

Step

Apply the same formula to multiple dates, if needed, by clicking the square icon -- also known as the fill handle -- that appears at the bottom-right corner of the cell that holds the formula you just created and dragging it to other cells.