Returning an entry from a table based on the current date

Hi, I hope someone can help me on this one as I was struggling for hours last night trying to use lookups, index and match scenarios but was getting nowhere,

In the attachment is a table with every date in a year, and I want to be able to return the week number in col 1 based on the current date. So the formula looks up today's date using the now() function in the table (14th Aug) and returns me 33. I don't know if its the now() that's causing the problem because it is looking for the date and time etc or should that not matter?

Thanks

John

While I'm sure it can be done with a lookup you're not overlooking:

=WEEKNUM(I2)

Are you?

Thanks for the help on this guys. I'm actually using the Australian financial calendar, so Week 1 is actually 30 June 2012. I had the weeks wrong in the example I posted. Do you know how I can get it to return the Week number for that calender?

Is it as simple as:

=WEEKNUM(NOW()-181)