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

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

Hi, how about using =weeknum(yourdate)

"squared chart area" wrote:

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

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

"John Moore" wrote in message
...
Hi, how about using =weeknum(yourdate)

"squared chart area" wrote:

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

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

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


"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