Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Quick Excel question

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Quick Excel question

Old 10-17-07, 12:57 AM
  #1  
DVD Talk Special Edition
Thread Starter
 
Join Date: May 2000
Posts: 1,219
Likes: 0
Received 0 Likes on 0 Posts
Quick Excel question

I am trying to make a list of dates in a single column in Excel. I want the dates to be two weeks apart. Is there a formula for "Previous cell"? Or do I have to enter the info into each cell? Currently I have set the date into the first cell, and then used "=A10+14", "=A11+14", "=A12+14" But it would be easier if I could just use one formula for all of the cells. I am looking in the help file for a command like this, but I figured I would ask here, in case someone knew how to do it.
Old 10-17-07, 01:19 AM
  #2  
DVD Talk Hero
 
D.Pham4GLTE (>60GB)'s Avatar
 
Join Date: Jul 2001
Location: Stick out your tongue!
Posts: 39,346
Likes: 0
Received 0 Likes on 0 Posts
click on the cell where you have the equation, and mouse over the lower right corner. It should change to a "+" sign, then just hold the left click button and drag the mouse down as far as you want it to go.
Old 10-17-07, 01:24 AM
  #3  
DVD Talk Limited Edition
 
Join Date: Dec 2001
Location: Bremerton WA
Posts: 5,748
Received 0 Likes on 0 Posts
You can also highlight the column starting with the last cell containing the formula and hit CNTRL + D.
Old 10-17-07, 01:32 AM
  #4  
DVD Talk Special Edition
Thread Starter
 
Join Date: May 2000
Posts: 1,219
Likes: 0
Received 0 Likes on 0 Posts
Originally Posted by Nesbit
You can also highlight the column starting with the last cell containing the formula and hit CNTRL + D.
Ah, thanks, that saved me about an hours worth of typing
Old 10-17-07, 09:35 PM
  #5  
DVD Talk Special Edition
 
danwiz's Avatar
 
Join Date: Dec 2000
Location: Fairbanks, Alaska
Posts: 1,858
Received 0 Likes on 0 Posts
Seems the most logical way is to enter the first date you want. Then select that cell and as many cells below it as you want to "fill". Then use the "EDIT", "FILL", "SERIES", command and make the "Step Value" 14 (after selecting the type of date you want).

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.