Date grouping

[Farida]

Hi All,
I need help with date grouping. I do apologize if I am in the wrong forum because I did almost same request in the Excel VBA programming and until now I didn’t back any help
I would like to group a month (for all 12 months) into 4 groups and i.e.
From 01/MM/YYYY – 07/MM/YYYY = Period 1
From 08/MM/YYYY – 14/MM/YYYY = Period 2
From 15/MM/YYYY – 21/MM/YYYY = Period 3
From 22/MM/YYYY – end of the month/MM/YYYY = Period 4
Colum A has all dates from Jan 1 until Dec 31 that is 366 rows (for whole calendar year), I need to use formula in column B to group them as Period 1 to period 4 and this will repeat in all months. The date format will be as follows
Column A Column B
01/01/2012 Period 1
02/01/2012 Period 1
03/01/2012 Period 1
04/01/2012 Period 1
05/01/2012 Period 1
06/01/2012 Period 1
07/01/2012 Period 1
08/01/2012 Period 2
And so on...
I would appreciate very much your help. I will wait for an answer and I hope I explained it properly.

[benishiryo]

hi Farida, you may try either of this:
=IF(DAY(A2)<8,"Period 1",IF(DAY(A2)<15,"Period 2",IF(DAY(A2)<22,"Period 3","Period 4")))
=LOOKUP(DAY(A2),{0,8,15,22},{"Period 1","Period 2","Period 3","Period 4"})

[Farida]

Thats wonderful......they worked, both of them.
Thank you very much

[Cutter]

@ Farida

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.