Dates in a week number
 

How do I find the dates that are in a week number? Assume Sunday is first
day.

Hi Mike

Take a look at
http://www.rondebruin.nl/isodate.htm


--
Regards
Roger Govier
"Mike Fogleman" wrote in message
...
How do I find the dates that are in a week number? Assume Sunday is first
day.

lets say you have the weeknumber in cell A1, and lets say you want to find
all the 7 days in the year 2005, then use the following formula to get the
first day in your weeknum:

=DATE(2005,1,1)+((A1-2)*7+(8-WEEKDAY(DATE(2005,1,1))))

and then add 1 six times to get the subsequent days.

Mangesh



"Mike Fogleman" wrote in message
...
How do I find the dates that are in a week number? Assume Sunday is first
day.

Very good! Thank you.
"Mangesh Yadav" wrote in message
...
lets say you have the weeknumber in cell A1, and lets say you want to find
all the 7 days in the year 2005, then use the following formula to get the
first day in your weeknum:

=DATE(2005,1,1)+((A1-2)*7+(8-WEEKDAY(DATE(2005,1,1))))

and then add 1 six times to get the subsequent days.

Mangesh



"Mike Fogleman" wrote in message
...
How do I find the dates that are in a week number? Assume Sunday is first
day.

forgot to mention: you will require to enable the Analysis ToolPak addin to
use the formula below.

Mangesh



"Mangesh Yadav" wrote in message
...
lets say you have the weeknumber in cell A1, and lets say you want to find
all the 7 days in the year 2005, then use the following formula to get the
first day in your weeknum:

=DATE(2005,1,1)+((A1-2)*7+(8-WEEKDAY(DATE(2005,1,1))))

and then add 1 six times to get the subsequent days.

Mangesh



"Mike Fogleman" wrote in message
...
How do I find the dates that are in a week number? Assume Sunday is
first
day.