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.

Is it possible to get numbers to insert a weekly date instead of a daily date?

I'm trying to set up an attendance sheet for my new martial arts class and I'd like to have the date inserted automatically but I can only get it to do this with a daily increment and I would like it to be weekly as in each Wednesday when I run my class.

Posted on Sep 3, 2021 4:22 AM

Reply
Question marked as Top-ranking reply

Posted on Sep 3, 2021 7:28 AM

Hi roobydob,


Method 1.


Type the first date in A2

Formula in A3: A2+7

(Numbers assumes that 7 means 7 days).

Hover the cursor over the the bottom border of A3 and drag the Fill Handle (yellow dot) down.



The formulas are copied down. You may want to Copy those cells and Menu > Edit > Paste Formula Results.


Method 2.


Type the first two dates and select both cells.


Drag the yellow dot down.


In Method 2, no formulas are involved. No need to Paste Formula Results.


Regards,

Ian.

3 replies
Question marked as Top-ranking reply

Sep 3, 2021 7:28 AM in response to roobydob

Hi roobydob,


Method 1.


Type the first date in A2

Formula in A3: A2+7

(Numbers assumes that 7 means 7 days).

Hover the cursor over the the bottom border of A3 and drag the Fill Handle (yellow dot) down.



The formulas are copied down. You may want to Copy those cells and Menu > Edit > Paste Formula Results.


Method 2.


Type the first two dates and select both cells.


Drag the yellow dot down.


In Method 2, no formulas are involved. No need to Paste Formula Results.


Regards,

Ian.

Is it possible to get numbers to insert a weekly date instead of a daily date?

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