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 ,
"Lewej" 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 ,
"Lewej" 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