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?
Question marked as
Best reply
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