Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

That title might have made my issue sound more complex than it is...

I am trying to figure out take one cell.... say A1 and put a date in it.... then move down several thousand rows and give another date 3 months later... and have it auto fill the dates between the two...

      (M/D/Y)

            COL A
  Row1      1/5/2012   (january)
   -
   -
   -
   -
Row 3250    3/5/2012    (only 3 months later but thousands of rows)

I want it ONLY to increment by day... But to do it evenly.... Like in blocks so:

number of days the same = rows (3250... or whatever it may be) / days (90)

Count the number of rows between.... then the number of days... then divide them up so that there are even blocks of days between... Maybe just putting the remainder if any on the end?

Does that make sense? THANK YOU FOR HELPING

share|improve this question

migrated from stackoverflow.com Nov 30 '12 at 7:46

This question came from our site for professional and enthusiast programmers.

    
How many rows are you using per day..? –  David Thomas Nov 29 '12 at 22:32
    
thats what i need to figure out... I think?! If you divide those two numbers (3250rows/90days) it would tell you the number that I would like to increment by.... I believe? basically the rows are publish dates for articles on a website... I would like to publish them evenly over 3 months... even though there are thousands or hundreds or articles (number of articles may vary) –  DigitalMediaGuy Nov 29 '12 at 22:36
    
I have made some progress... If you divide the number of rows/days it gives you the number of rows that should contain the same date... So now I just need some formula or excel method to take a start date and copy it / fill it down for the number of days from (rows/90days)... Does anybody know how to do it? Thanks again :) –  DigitalMediaGuy Nov 29 '12 at 22:52

3 Answers 3

If your first date is in A1 and last date in A31, this should do the trick

=INT((ROW(A2)-ROW(A$1))/(ROW(A$31)-ROW(A$1))*INT((A$31-A$1)/90))*90+A$1

Where you can replace 90 (both occurences) by the number of days between each step.

share|improve this answer

The Fill Series command will fill in the gaps. Highlight the range including the first and last date. On the Home tab, in the Editing group choose the Fill command and Series. Just check the Trend box and click OK, and it should work out the steps required to fit.

share|improve this answer
    
Select "Columns" and "Linear" also! –  pnuts Nov 30 '12 at 19:53
  1. Fill next row
  2. Select this two rows
  3. Drag to corner and spread it to your date

This works with any numerable objects - "a,b,c...", "1,2,3..""p1,p2,p3.." etc. Also works with different formulas with dinamic or static values

share|improve this answer
    
OP wants a date 3 months later (say 91 days or so) spread over several thousand rows. I don't think your solution is the answer to his question, though it may be the basis or an answer. –  pnuts Nov 30 '12 at 9:06
    
whatever, just formula not enought for filling cells/rows. It must be or my way with cells selection or VB-macros –  Sugar Nov 30 '12 at 10:15

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.