Transpose week numbers to date

Hi
One of my users would like to have certain cells in his spreadsheet, where
if you type a week number it will transpose it to a date.

For example 01 might be 01/04/2005, 02 might be 08/04/2005 and 52 might be
25/03/2006.

I am clueless on this one, and not very good at Excel anyhow

Thanks in advacne

Harry

One way:

Assume the week number is input into cell A1:

B1: =DATE(2005,4,1) + 7 * (A1-1)


Format the cell as a date.

Note that I get 24/03/2006 rather than 25/03/2006 for A1=52.

In article <27203F81-566E-4539-A116-56FA9F1219F6@microsoft.com>,
"Lewej" <Lewej@discussions.microsoft.com> wrote:

> One of my users would like to have certain cells in his spreadsheet, where
> if you type a week number it will transpose it to a date.
>
> For example 01 might be 01/04/2005, 02 might be 08/04/2005 and 52 might be
> 25/03/2006.
>
> I am clueless on this one, and not very good at Excel anyhow

Thanks JE - I'll give it a go
Cheers
Lewej

"JE McGimpsey" wrote:

> One way:
>
> Assume the week number is input into cell A1:
>
> B1: =DATE(2005,4,1) + 7 * (A1-1)
>
>
> Format the cell as a date.
>
> Note that I get 24/03/2006 rather than 25/03/2006 for A1=52.
>
> In article <27203F81-566E-4539-A116-56FA9F1219F6@microsoft.com>,
> "Lewej" <Lewej@discussions.microsoft.com> wrote:
>
> > One of my users would like to have certain cells in his spreadsheet, where
> > if you type a week number it will transpose it to a date.
> >
> > For example 01 might be 01/04/2005, 02 might be 08/04/2005 and 52 might be
> > 25/03/2006.
> >
> > I am clueless on this one, and not very good at Excel anyhow
>