Consecutive dates/numbers

How to automatically fill consecutive dates



iMac, OS X 10.11

Posted on Feb 28, 2021 6:55 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 28, 2021 7:21 AM

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




1 reply
Question marked as Top-ranking reply

Feb 28, 2021 7:21 AM in response to rheegan

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




This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Consecutive dates/numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.