Transpose week numbers to date

[Lewej]

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

 

[JE McGimpsey]

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.

 

[Lewej]

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

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.