Dates in a week number

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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#9jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> > 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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> How do I find the dates that are in a week number? Assume Sunday is first
> day.
>

Very good! Thank you.
"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:%239jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
>> 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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#9jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> > 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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> How do I find the dates that are in a week number? Assume Sunday is first
> day.
>

Very good! Thank you.
"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:%239jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
>> How do I find the dates that are in a week number? Assume Sunday is first
>> day.
>>
>>
>
>

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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> 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" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:#9jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> > 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" <mikefogleman@insightbb.com> wrote in message
news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
> How do I find the dates that are in a week number? Assume Sunday is first
> day.
>

Very good! Thank you.
"Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
news:%239jptq2kFHA.4000@TK2MSFTNGP12.phx.gbl...
> 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" <mikefogleman@insightbb.com> wrote in message
> news:uerd1j2kFHA.3380@TK2MSFTNGP12.phx.gbl...
>> How do I find the dates that are in a week number? Assume Sunday is first
>> day.
>>
>>
>
>