XL IF formula to calculate Number of weeks based on dates in Column:

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.

Here, try this:

="week "&1+WEEKNUM(A1,2)-WEEKNUM(EOMONTH(A1,-1)+1,2)

Hi Zbor,

I hope it's calculating the week # for the entire year. I mean to say, I'm getting week # as Week # as "Week - 38" too. As per my understanding it should calculate teh # of weeks for any particular month for which teh date is given, say for example it can't go beyond Week 5 for any month.

Please let me know if I'm not clear in expressing my requirement clearly.

Thanks
Sancy.

Hi Zbor, Sorry, I apologise. It's working fine. I made some mistake earlier. Sorry for teh inconveniences if any. Could you please help me to find teh Month too in a seperate column?

Thanks & Regards
Sancy.

=A1 and format cell as mmmm