1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Need Quick Excel Help!!!!

Discussion in 'BlackHat Lounge' started by JuicyBlack, Mar 21, 2010.

  1. JuicyBlack

    JuicyBlack Regular Member

    Joined:
    Nov 27, 2008
    Messages:
    395
    Likes Received:
    179
    Location:
    Dark n Wet Place
    Hey guys,

    Using this screenshot as a reference:

    [​IMG]

    I am trying to set up Column H to to display the dates entered in column F (Adding 7 days to show the due date). In other words Column H should show the Order date + 7 which is the due date. I know that adding a date is easy ... If I click on H3 and type =F3+7 that cell will show the due date fine.. but I need to set the entire H3 column to show the due date based on the data I input on each cell of column F ..

    That way when I type Mar 22 in say cell F10, cell H10 will automatically show Mar 29 as the due date...

    Any ideas how to set this up?
     
  2. thebug

    thebug Newbie

    Joined:
    Oct 29, 2009
    Messages:
    20
    Likes Received:
    6
    I'm not sure I am understanding you entirely because it looks like you are doing it right. Are you saying instead of typing in each cell in column H "=F3+7", "=F4+7", "=F5+7", etc, you want a short-cut? If that's the case then just place your mouse over the bottom right corner of the cell (H3 for example, which has your F3+7 formula) until the pointer turns into a black plus symbol, and then click and drag down while holding the mouse button. If that's not what you need, please clarify... HTH
     
    • Thanks Thanks x 1
  3. BozoClown

    BozoClown Junior Member

    Joined:
    Jan 4, 2009
    Messages:
    150
    Likes Received:
    106
    Doesn't =:F1 + 7 the paste over all of column H work?
     
    • Thanks Thanks x 1
  4. M2Money

    M2Money Newbie

    Joined:
    Nov 28, 2008
    Messages:
    34
    Likes Received:
    6
    copy the first cell of H3 and select all the remaining rows of colum H3 and hit ENTER...
    that copies the formula to all cells in col H3...

    HTH
    Posted via Mobile Device
     
    • Thanks Thanks x 1
  5. JuicyBlack

    JuicyBlack Regular Member

    Joined:
    Nov 27, 2008
    Messages:
    395
    Likes Received:
    179
    Location:
    Dark n Wet Place
    Ahh there we go... I knew it was something easy but since I haven't touched excel in a long while I was getting all flustered over such simplicity :)

    Thank u so much guys!