Hi,

I would look at the WEEKNUM function. This is an ATP function in 2003 or
earlier. So you need to choose Tools, Add-ins and check the Analysis ToolPa.
then look at the Hep for this function.

You will need to define what you mean by calendar week, this varies from
country to country. You will also need to tell us what will trigger the
display of the days in the desired week. Are you entering KW12 in cell A1?
Or what?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Lalit Sharma" wrote:

Dear friends,
I have a value let's say KW12 (calender week 12) in year 2009 and I want
excel to list all the dates that falls under KW12.
Please advice!
Brgds, LS