How do you create a weekly autofill in Numbers

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

You are welcome,

Thanks for the green checkmark.

Barry