Weekly Chart Beginning with Sunday

[MiriBella]

Hello All,

I need to create a weekly chart beginning with Sunday's date. For example 2018:

Jan 7
Jan 14
Jan 21
Jan 28
Etc....

Thank you for your help!

[Sam Capricci]

what is it you need exactly? If you put 1/7/2018 in cell A1, then 1/14/2018 in cell A2 then grab the little box at the bottom right of cell A2 and drag down excel will autopopulate the rest of the values 7 days apart for as far down as you drag your cursor.

[MiriBella]

Yes, but I can't get it to display as Jan 1. It displays as 1-Jan. But it's ok. I'll just keep that format. Thank you!

[Sam Capricci]

go to custom format and under Type: enter "mmm d" (without the quotes) and that should take care of it for you.

[MiriBella]

Thank you! You're awesome!

[JohnTopley]

Format as "mmm dd" (without quotes)

[MiriBella]

Thank you also, John!

[Sam Capricci]

you're welcome! and thank you for the rep!