I need to go back to school! Help w/ formula please..
I promise to register for an Excel class next semester! For now I need a
quick fix pretty please? There has to be an easier way besides typing the same formula row after row after row.. Here's what I am trying to do... A B 1 1-3-2006 7 2=A1+B1 3 4 This works fine giving me the date of 1-10-2006 in cell A2. What I cant get is how can I take the answer (value?) to my formula given to me in cell A2 and continue down the row. It would look something like this... A B 1 1-3-2006 7 2 1-10-2006 3 1-17-2006 4 1-24-2006 5 1-31-2006 In other words I would like to make a list of dates a week apart starting with 1-3-2006 and continue down the column. I'm sure I've made this more complicated in my head than it needs to be. Maybe I've been staring at it too long! =-) Comments encouraged.. Thanks, B |
I need to go back to school! Help w/ formula please..
Just put the 7 in your formula. In A2 enter =a1+7. Copy that down.
"Bambers" wrote: I promise to register for an Excel class next semester! For now I need a quick fix pretty please? There has to be an easier way besides typing the same formula row after row after row.. Here's what I am trying to do... A B 1 1-3-2006 7 2=A1+B1 3 4 This works fine giving me the date of 1-10-2006 in cell A2. What I cant get is how can I take the answer (value?) to my formula given to me in cell A2 and continue down the row. It would look something like this... A B 1 1-3-2006 7 2 1-10-2006 3 1-17-2006 4 1-24-2006 5 1-31-2006 In other words I would like to make a list of dates a week apart starting with 1-3-2006 and continue down the column. I'm sure I've made this more complicated in my head than it needs to be. Maybe I've been staring at it too long! =-) Comments encouraged.. Thanks, B |
I need to go back to school! Help w/ formula please..
Try this: Enter 1/3/2006 in A1.
In A2 type =A1+7 then copy formula down. "Bambers" wrote in message ... I promise to register for an Excel class next semester! For now I need a quick fix pretty please? There has to be an easier way besides typing the same formula row after row after row.. Here's what I am trying to do... A B 1 1-3-2006 7 2=A1+B1 3 4 This works fine giving me the date of 1-10-2006 in cell A2. What I cant get is how can I take the answer (value?) to my formula given to me in cell A2 and continue down the row. It would look something like this... A B 1 1-3-2006 7 2 1-10-2006 3 1-17-2006 4 1-24-2006 5 1-31-2006 In other words I would like to make a list of dates a week apart starting with 1-3-2006 and continue down the column. I'm sure I've made this more complicated in my head than it needs to be. Maybe I've been staring at it too long! =-) Comments encouraged.. Thanks, B |
I need to go back to school! Help w/ formula please..
B
First, you could do away with the 7 in B1 and just use =A1+7 in A2 With the formula in A2, select A2 and hover the cursor over the black square at right-hand bottom corner of the cell. When you see a black cross, left-click and drag down column A to copy the formula. The cell references will increment as you drag down. If you wish to use the 7 and refer to B1 you must enter in A2 =A1+$B$1 The $ signs lock B1 as the cell with the value. A1 will change to A2 and A3 and A4 as you drag/copy down. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 16:22:02 -0700, Bambers wrote: I promise to register for an Excel class next semester! For now I need a quick fix pretty please? There has to be an easier way besides typing the same formula row after row after row.. Here's what I am trying to do... A B 1 1-3-2006 7 2=A1+B1 3 4 This works fine giving me the date of 1-10-2006 in cell A2. What I cant get is how can I take the answer (value?) to my formula given to me in cell A2 and continue down the row. It would look something like this... A B 1 1-3-2006 7 2 1-10-2006 3 1-17-2006 4 1-24-2006 5 1-31-2006 In other words I would like to make a list of dates a week apart starting with 1-3-2006 and continue down the column. I'm sure I've made this more complicated in my head than it needs to be. Maybe I've been staring at it too long! =-) Comments encouraged.. Thanks, B |
I need to go back to school! Help w/ formula please..
I just got home and tried your suggestions and TAADAAA! It was that easy all
along. Thanks bpeltzer, RHinNC and Gord Dibben. You peeps saved my day. Most appreciated, B |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com