Excel Formating

  • Thread starter Thread starter Cougtony
  • Start date Start date
C

Cougtony

Hi, Simple question. I have a spreadsheet with a list of dates in a colum and
I want it to automatically update as I copy. I.E. A1 cell has 9/5/2007 and i
want in A2 and as far as I copy and paste it to add to the correct date A2
9/6/2007, A3 9/7/2007 and so on
 
From your description I guess you want to increase each cell by one day?
If so, simple answer:
in A2 enter =A1+1 and copy down as far as you wish.
If you then want the dates to remain 'as is' then Copy - Paste Special -
Value (you may then need to format the cells to your date format) otherwise
if you subsequently change a date all those dates below will change!
Hope this is what you require?
 
From what i understand in your question. If A1 is populated with date
9/5/2007 and you want a2-a100 to be populated with next date in order. just
click on a1 and place mouse cursor on lower right hand side and left click
and hold pull down to whatever cell you want this to populate. You might
want to make sure you have the colum formated to the style date you perfer.
 
Back
Top