Thanks A Lot Bernie for help, Nice idea.. works well
The weeks were in that formate: W33 (in cell A2)
So, I used
=value(mid(A2,2,2))



"Bernie Deitrick" wrote:

It depends on your week numbering scheme: something along the lines of

=DATE(2007,12,24)+WkNum*7

That will give 12/31/2007 as the start date of week 1...

HTH,
Bernie
MS Excel MVP


"squared chart area" wrote in message
...
Hello,

I would like to know how can i get the start date of a given week number?
Any help on this?

Thanks in advance