Autofill

  • Thread starter Thread starter Mrich
  • Start date Start date
M

Mrich

I would like to autofill dates in a row which I know how to do but what I
need to do is have the same date in 2 cells before progressing on the the
next date and so on.
For example, I need this :
04/01/06
04/01/06
04/02/06
04/02/06
etc......
Any and all suggestions will be greatly appreciated.
Thanks in advance.
 
Put the date in the top cell (say A1).
Put the =A1 in the next cell (A2).
Put this in A3: =A1+1
put this in A4: =a1+1

Select A3:A4 and copy those cells down.

Select the range of cells
edit|copy
edit|paste special|values
(if you don't want the formulas)
 
Wonderful. That works.
Thanks very much.
Dave Peterson said:
Put the date in the top cell (say A1).
Put the =A1 in the next cell (A2).
Put this in A3: =A1+1
put this in A4: =a1+1

Select A3:A4 and copy those cells down.

Select the range of cells
edit|copy
edit|paste special|values
(if you don't want the formulas)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Receiving valid Multicast address failed on mini port driver 0
Using match to return value 1
Increment Account Numbers 1
max values in two ranges 4
How to avoid Duplicate values .. but want the first value to added in group totals 0
Excel 2010 autofill dates not correct progression 3
Find then highlight in yellow 6
Find first and last dates a reort was printed. 13

Back
Top