Consecutive dates/numbers
How to automatically fill consecutive dates
iMac, OS X 10.11
How to automatically fill consecutive dates
iMac, OS X 10.11
Not sure exactly what you mean but you can do things like this:
Enter the first two dates, select the two cells, and drag the yellow dot down:
Giving you:
You can also set your table up so a new date is entered when you add a row:
The formula in A3, filled down:
=A2+1
Now, when you are in the last row (which has no blank rows beneath it( and you hit enter to add a new row, a new date will automatically be entered in column A on the new row. You don't need to enter it.
Other formulas will also automatically be carried down to the new row.
SG
SG
Not sure exactly what you mean but you can do things like this:
Enter the first two dates, select the two cells, and drag the yellow dot down:
Giving you:
You can also set your table up so a new date is entered when you add a row:
The formula in A3, filled down:
=A2+1
Now, when you are in the last row (which has no blank rows beneath it( and you hit enter to add a new row, a new date will automatically be entered in column A on the new row. You don't need to enter it.
Other formulas will also automatically be carried down to the new row.
SG
SG
Consecutive dates/numbers