You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

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?

Posted on Mar 17, 2021 12:01 AM

Reply
Question marked as Top-ranking reply

Posted on Mar 17, 2021 12:28 AM

Use a single date in each cell, noting the beginning of the week.


Enter the starting date in A2,


Select cell A3 (one click) then press = toopen the Formula Editor.


Enter the formula below in the editor, then click the green checkmark to confirn the formula and close the Editor.


A2+"7d"


With cell A3 still selected, press command-C to copy the cell and its content (the formula).


Scroll to the bottom of th table.


Press the Shift key and click (once) the last cell in column A to expand the selection to include that cell and all cells between it and A3.


Press command-V to paste the formula into tall cells in the column.


IF you need the end of week dats as well, add a new column to the right of column A. In the new B2, enter the formula below:


A2+"6d"


Fill the formula down to the last cell in column B, using the same rocess as above.


Regards,

Barry



3 replies
Question marked as Top-ranking reply

Mar 17, 2021 12:28 AM in response to wyldenwindy

Use a single date in each cell, noting the beginning of the week.


Enter the starting date in A2,


Select cell A3 (one click) then press = toopen the Formula Editor.


Enter the formula below in the editor, then click the green checkmark to confirn the formula and close the Editor.


A2+"7d"


With cell A3 still selected, press command-C to copy the cell and its content (the formula).


Scroll to the bottom of th table.


Press the Shift key and click (once) the last cell in column A to expand the selection to include that cell and all cells between it and A3.


Press command-V to paste the formula into tall cells in the column.


IF you need the end of week dats as well, add a new column to the right of column A. In the new B2, enter the formula below:


A2+"6d"


Fill the formula down to the last cell in column B, using the same rocess as above.


Regards,

Barry



How do you create a weekly autofill in Numbers

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