+ Reply to Thread
Results 1 to 3 of 3

Bar chart for weeks of the year

  1. #1
    Forum Contributor
    Join Date
    10-29-2004
    Posts
    291

    Bar chart for weeks of the year

    I want to create a helper column within a sheet which will assign a week number (1-52) based on January 1st.

    A date of 1/3/14 would return 1

    A date of 1/8/14 would return 2

    A date of 2/2/14 would return 5 (as in the fifth week of the year)

    Does Excel contain an easy solution for this?

    I want to create a weekly chart showing sales totals for each week of the year.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Bar chart for weeks of the year

    Hi,

    Look on the net for "Excel WeekNum". The function is built into Excel. Which version of excel are you using as it makes a difference....
    http://office.microsoft.com/en-us/ex...010343016.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Bar chart for weeks of the year

    this would be a solution
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 10-04-2013, 10:04 AM
  2. Replies: 3
    Last Post: 05-29-2013, 01:57 PM
  3. Fiscal Year 2010 has 91 weeks?
    By smninos in forum Excel General
    Replies: 2
    Last Post: 02-01-2011, 12:15 PM
  4. [SOLVED] 53 weeks in 2004 skews x-axis year increment on charts.
    By bj.williams in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-07-2006, 06:50 PM
  5. Create fiscal Year calendar list weeks by #1-52
    By akid12 in forum Excel General
    Replies: 0
    Last Post: 06-14-2005, 07:05 PM

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