Numbers speed sheet

Is there a way to populate a column, progressing to the next month each row? (with same day of the month)

Posted on Jun 17, 2021 11:28 AM

Similar questions

How do I create a column in Numbers which displays date and time increasing? How do I create a column in numbers which displays date and time increasing by 30 min intervals? Cannot see anything in Numbers Help to achieve this. [Re-Titled by Moderator]
1671 6
How can I locate the "Month and Year" sheet in numbers Calendar Template? Hello, I am looking to incorporate the monthly tables from the Calendar template into a larger work sheet i am working on, so I can edit them as I need alongside other data they need to sit along. However, when copying the tables, I noticed that not all the formula will copy along. Specifically the WEEKDAY formula, which the whole month day schedule is linked to won't copy, as it appears it's linked to a "Month and Year" sheet, which I don't seem to locate. As a results, when copying the months in a different file, I can change the months, but the weekly days won't change accordingly. Would you be able to tell me how I can locate the "Monthly and Year" sheet and if it's possible to copy it into another file, so to ensure the monthly tables work? I include a photo illustration to support my question. Thanks for the help! Cinzia
522 4
How do you create a weekly autofill in Numbers I don't know how to create an automatic function to fill in weekly dates in numbers. At the moment I'm filling them in manually. Can anyone help me?
1859 3

3 replies

Barry

Level 9

60,047 points

Jun 17, 2021 12:23 PM in response to olIAdude

Enter your starting date in the first cell (A2 for the example).

Select cell A3, type = to open the formula editor, then enter the formula below.

EDATE(A2,1)

Fill the formula down into as many rows as needed.

Regards,

Barry

olIAdude Author

Level 1

11 points

Jun 17, 2021 6:11 PM in response to Barry

Thanks Barry! works perfectly- very helpful.

Barry

Level 9

60,047 points

Jun 17, 2021 8:02 PM in response to olIAdude

You're welcome, ollAdude.

Thank you for the green checkmark.

Regards,

Barry

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.

Numbers speed sheet

Welcome to Apple Support Community

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

Learn more Sign up