Converting Week to Date

Hello.

I have a weeknumber that I want to convert to a date. I am interesting in the date which starts the current week.

Week 11: starts the 12th of march.
Week 12: starts the 19th og march.
How can I create a function that returns the date as above?

Does anyone have a simple solution for this?

/Anders

Hello.

Thanks alot.

You are great.

/Anders

If you want a solution that would work year to year I'd suggest that you need to define exactly how the week numbers work, there are several different systems. You'd also need to supply a week number and year...

But assuming you have a week number in A1 which relates to 2007 you could try

=DATE(2007,1,A1*7-6)