Excel [Format Cells] Help!

[K i a r a]

Hey,

So I am trying to make a Date row that Shows the weekly day, For example, every Saturday... Like this

Spoiler

 Is there a way to auto-fill this?

I have tried but it just repeats the same date.. Or is the only way to do this manually?

[Kochiha Ichihara]

Ah, one of the skills I had to learn working at Sears! Here's how:

1. Select a cell and type the first date (so 6/8/2018 based on your chart)
2. Then, in the next cell (let's use A2 for this case) type the formula =A1+7 and press Enter to get the second date.
3. Now you can just drag down the autofill handle to fill the weekly dates.

Only trouble is that this might not give you the month names. Would that be essential for what you're making?

[Dissitesuxba11s]

Highlight a majority of the dates then drag down, instead of just the last date.

[K i a r a]

16 hours ago, Kochiha Ichihara said:

Ah, one of the skills I had to learn working at Sears! Here's how:

1. Select a cell and type the first date (so 6/8/2018 based on your chart)
2. Then, in the next cell (let's use A2 for this case) type the formula =A1+7 and press Enter to get the second date.
3. Now you can just drag down the autofill handle to fill the weekly dates.

Only trouble is that this might not give you the month names. Would that be essential for what you're making?

hey!

Yeah, So I just got a Gecko, and doing weekly weighs / notes and such so i need month names