Formula Help - Date Ranges

[gigglesmumpty]

Hi all, I have a large number of records in excel where i would like to group the date depending what week it falls in our calendar month- for example if 04/01/15 is in week 1 then i'd like to have something like;

=if(date is between 01/01/15 and 07/01/15, "week 1"

However when I try a number of options to put this in place i am continually getting errors, ideally i'd like to make it a multiple list, so that the dates after the first can be arraged whether they are week 1 or week 31.

Hope this makes sense and thank you in advance for any assistance

[FlameRetired]

Perhaps something like this?

="Week "&WEEKNUM(A1)

	A	B
1	1/1/2015	Week 1
2	1/2/2015	Week 1
3	1/3/2015	Week 1
4	1/4/2015	Week 2
5	1/5/2015	Week 2
6	1/6/2015	Week 2
7	1/7/2015	Week 2
8	1/8/2015	Week 2
9	1/9/2015	Week 2
10	1/10/2015	Week 2
11	1/11/2015	Week 3
12	1/12/2015	Week 3
13	1/13/2015	Week 3
14	1/14/2015	Week 3
15	1/15/2015	Week 3
16	1/16/2015	Week 3
17	1/17/2015	Week 3
18	1/18/2015	Week 4
19	1/19/2015	Week 4
20	1/20/2015	Week 4
21	1/21/2015	Week 4
22	1/22/2015	Week 4
23	1/23/2015	Week 4

[FlameRetired]

Double posted.

[gigglesmumpty]

Thanks, I'll give that a go, I fear I was trying to make it far more complicated than necessary