+ Reply to Thread
Results 1 to 8 of 8

Weekly Chart Beginning with Sunday

  1. #1
    Registered User
    Join Date
    11-22-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    28

    Weekly Chart Beginning with Sunday

    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!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Weekly Chart Beginning with Sunday

    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.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    11-22-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Weekly Chart Beginning with Sunday

    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!

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Weekly Chart Beginning with Sunday

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

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,001

    Re: Weekly Chart Beginning with Sunday

    Format as "mmm dd" (without quotes)

  6. #6
    Registered User
    Join Date
    11-22-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Weekly Chart Beginning with Sunday

    Thank you! You're awesome!

  7. #7
    Registered User
    Join Date
    11-22-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Weekly Chart Beginning with Sunday

    Thank you also, John!

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Weekly Chart Beginning with Sunday

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Return next Sunday's date beginning this Friday.
    By josephdemars in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-22-2015, 02:13 PM
  2. [SOLVED] Weekly average formula (outputs only on last data entry of Sunday)
    By dinker454 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2013, 02:09 AM
  3. Weekly average output for last entry on every Sunday night shifts
    By dinker454 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-18-2013, 11:51 AM
  4. Replies: 3
    Last Post: 03-13-2012, 02:14 PM
  5. Replies: 3
    Last Post: 02-05-2012, 10:04 AM
  6. Get Weekly Report Start Sunday ?
    By phpmann in forum Excel General
    Replies: 0
    Last Post: 10-12-2008, 01:42 PM
  7. [SOLVED] Sunday to Saturday weekly foreward planner
    By leub in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2006, 12:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1