View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default get the week start date

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