get the week start date

[squared chart area]

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

 

[Bernie Deitrick]

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

 

[John Moore]

Hi, how about using =weeknum(yourdate)

 

[squared chart area]

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))

 

[Rick Rothstein \(MVP - VB\)]

This should work for any year (just change the two occurrences of 2008 in my
formula to the year you want to calculate for; or, better still, make them
cell references and set the year value in that cell)...

=DATE(2008,1,1)-WEEKDAY(DATE(2008,1,1))-6+7*WkNum

It assumes the week starts on Sunday, If you want it to start on a Monday
(as Bernie's routine does), then change the -6 to a -5.

Rick