get the week start date

S

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
 
B

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
 
D

David Biddulph

The OP was asking how to get a start date from a week number, not vice
versa, John.
 
S

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

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
 
Top