Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I automatically calculate a series of dates 7 weeks from the starting date?

Posted on 2011-03-12
4
Medium Priority
?
269 Views
Last Modified: 2013-11-05
Cell A1 has 1/1/2011.  I want cell A2 to be seven weeks from  cell A1, cell A3 to be seven weeks from cell A2, etc.
0
Comment
Question by:bobbat
4 Comments
 
LVL 7

Accepted Solution

by:
Brad Sims, CCNA earned 1760 total points
ID: 35118797
The simplest way is just to add 49 (the number of days) to the value in A1.

=SUM(A1+49)

0
 
LVL 4

Assisted Solution

by:mawni
mawni earned 80 total points
ID: 35119334
I agree with JOHN, there are much functions to do this, but the simplest way is just adding 47
0
 
LVL 4

Assisted Solution

by:ashishgamre11
ashishgamre11 earned 80 total points
ID: 35120299
Yes, you can write
=SUM(A1+49)
in cell A2.

You can drag the formula to A3,A4,.. and onwards.

or write
=SUM(A2+49)
in cell A3

=SUM(A3+49)
in cell A4 .. and onwards
0
 
LVL 50

Assisted Solution

by:barry houdini
barry houdini earned 80 total points
ID: 35122681
SUM function is unnecessary here, all you need is this formula in A2 copied down

=A1+49

regards, barry
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question