Excel – How autofill all rows between two dates in excel with the second date as the incrementing limit

date timemicrosoft excelworksheet-function

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?

Best Answer

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.

Related Question