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.
Bookmarks