How to Add 12 Weeks to a Date in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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

Step 1

Image Credit: Image courtesy of Microsoft

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.

Advertisement

Video of the Day

Step 2

Image Credit: Image courtesy of Microsoft

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

Advertisement

Step 3

Image Credit: Image courtesy of Microsoft

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

Advertisement

Step 4

Image Credit: Image courtesy of Microsoft

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).

Advertisement

Advertisement

Step 5

Image Credit: Image courtesy of Microsoft

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.

Advertisement

Advertisement

Video of the Day

references

Report an Issue

screenshot of the current page

Screenshot loading...