2-Sep-12 September Week1
8-Sep-12 September Week2
15-Oct-12 October Week3
31-Oct-12 October week5

Hi All, I need your help to create a simple formula, which will help me to ascertain the Number of Week, and Month the given date from a month will fall in. As given above, the data will be stored in 3 columns, 1st one containing dates, secondone containing Month and in 3rd column the Week Number for that particular Month.

In reality the date column will have n number of such dates and I need some easy way to find out Month and Week.

Your help will be much appreciated.
Thanks in advance.
Sancy.